Viewing 15 posts - 271 through 285 (of 694 total)
Thanks Lynn
I will do just that for you. I will post it in just a bit
I am able to replace the last pipe, with a different character, I can now...
October 7, 2011 at 11:09 am
Yes, that I could. I can use C# in a SSIS package. My problem is that I am not sure where to begin with it.
I am able to replace the...
October 7, 2011 at 11:07 am
Thanks Buddy
I was hoping someone may have known of something.
I guess I will stick with doing it the hard way then.
Have a good one.
Andrew SQLDBA
October 5, 2011 at 9:36 am
Oops
So sorry about misspelling your name Elliott
Thank You again
Andrew SQLDBA
September 23, 2011 at 9:33 am
Thank you Elliot
That works perfectly
Andrew SQLDBA
September 22, 2011 at 5:30 pm
Oh dang, I cannot believe that I cannot read the SQL BOL.
I think that it may be time for lunch.
I am still missing something. I can get the firstname fine,...
August 2, 2011 at 11:57 am
I have tried CHARINDEX, even after replacing the caret with a numeric value, and CHARINDEX is still returning a 0
I replaced the caret with the number 8, which will never...
August 2, 2011 at 11:23 am
Thank you Everyone for all the suggestions.
I am going to use the suggestions presented, and then load some data into the database via a .NET front-end, and see how well,...
August 1, 2011 at 3:58 pm
I just thought of something after I sent the reply.
I can use either SSIS or a SQL job to query the table, and if there are rows in the table,...
July 29, 2011 at 1:14 pm
Not that I can figure out. This is an old app that should have been done away with decades ago.
I have to use the insert statement within the app, and...
July 29, 2011 at 1:09 pm
Hey Buddy
That did the trick, thank you so very much.
Andrew SQLDBA
July 28, 2011 at 5:56 pm
No, Developer Edition is the same as all the others. It only allows a certain number of concurrent connections.
Could be the user was admin on the box, or in the...
July 20, 2011 at 4:13 pm
Thanks Everyone
Finally this junk is beginning to look like usable data.
Andrew SQLDBA
July 20, 2011 at 3:19 pm
I just noticed that the sample data that I posted had all the consecutive blanks removed. So my sample did not look correct.
LOL
Andrew SQLDBA
July 20, 2011 at 2:56 pm
It is not that there are only double spaces, there are many multiple spaces. I guess that I could run that query over and over, eventually it will all run...
July 20, 2011 at 2:55 pm
Viewing 15 posts - 271 through 285 (of 694 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy