Viewing 12 posts - 1 through 12 (of 12 total)
Thanks very much for a great article. Some of the methods I knew, but others were an education for me. Appreciate your time and efforts!
October 26, 2016 at 6:25 am
Sergiy,
I did read Luis' post and incorporated it in an even more graceful and shorter solution that best suited my need.
In the future, maybe you ought to question what you...
October 26, 2016 at 5:55 am
Well said, and understood - all good point. And yes, the solution I found actually came from a number of members, yourself included.
Thanks for that!
October 26, 2016 at 5:38 am
Point taken, and most of the time, good advice. Thanks for offering it!
October 25, 2016 at 1:57 pm
Jeff - Look at the fourth and sixth small paragraph of my original post. I did exactly what you are suggesting I did not do. I asked to...
October 24, 2016 at 6:09 am
Alex,
Here is the basic code I used. This produces a nice temp table of information and of course, you can edit the query if you don't want all the...
October 21, 2016 at 9:09 am
Hanshi,
Thanks for your reply, but unfortunately its way over-complex. I found a way to do this that is simple and elegant.
1. Run SP_COLUMNS and direct output to a Temp...
October 21, 2016 at 8:22 am
Luis,
No - it was not a problem - I saw what you were doing but it wasn't quite what I was after (my fault, not yours).
October 21, 2016 at 7:38 am
I Brandie,
Let me try to provide you some answers...
We use SSIS when its truly needed, but sometimes we actually use old DTS, or even just an ASCII dump directly into...
October 21, 2016 at 7:36 am
My apologies Brandi - you're right - you did say that in your edit. However, you also just addressed constraining the columns entry when I asked a very simple...
October 21, 2016 at 6:52 am
My thanks to all who responded, but please, in the future, read the question - I DID NOT say "Users are entering data", what I said was "We get tables"...
October 21, 2016 at 6:24 am
Thanks Drew... That worked swimmingly!!!
October 18, 2016 at 11:05 am
Viewing 12 posts - 1 through 12 (of 12 total)