Viewing 15 posts - 49,561 through 49,575 (of 59,078 total)
dfalso (6/27/2008)
And to me, I wouldn't presume that 11000 was enough for anything except days since 1970ish.
How many times have you personally needed a Tally table larger than 11,000? 😛
June 27, 2008 at 11:14 pm
dfalso (6/27/2008)
June 27, 2008 at 10:48 pm
Matt Miller (6/27/2008)
Otherwise - it's very easy to come up with a numbers table of...
June 27, 2008 at 10:45 pm
Oh no... about 99% of everything you need to do can be done with a Tally table of 11,000 rows. If you need more than that, you can create...
June 27, 2008 at 7:27 pm
Aye. Thanks for the feedback... I sometimes wonder if posts like that do any good. 🙂
June 27, 2008 at 6:36 pm
David Jackson (6/27/2008)
Hats off to Jeff M for teaching us this trickEdit: I see Matt beat me to it, but he is spot on, forget loops if you can.
Thanks...
June 27, 2008 at 6:34 pm
Mark (6/27/2008)
But I got errors.
Can't read your mind, Mark... please post the exact text from the errors...
June 27, 2008 at 6:30 pm
zxn001 (6/27/2008)
Ok... so basically when you ask it to opperate a command on a column...
THAT, is the basis of set based programming. THAT, is the necessary paradigm shift necessary...
June 27, 2008 at 6:28 pm
dfalso (6/27/2008)
Also, depending on need, you can adapt the above to dynamic SQL should you want to work with input parameters.
Why would you need to do that?
June 27, 2008 at 6:25 pm
Michael has the right idea for you helping us to help you.
In the meantime, lookup "Cross Join" in Books Online...;)
June 27, 2008 at 12:29 pm
Tom Garth (6/27/2008)
There are some assumptions in what I'm about to say.
That's a heck of a good explanation, Tom...
To put it in laymen's terms, there are two ways to buy...
June 27, 2008 at 12:26 pm
zxn001 (6/27/2008)
And you made me a believer, a very confused one, but still believing.
So now I'm really curious, WHY does the set loop work...
June 27, 2008 at 12:19 pm
Basically, I use batch files to do the transfers like Matt suggested. You're moving files... why not let the thing that handles files the best do it... namely the...
June 27, 2008 at 12:12 pm
Validation of the text files should be done either during the creation of the text file, during the import of the text file, or, preferably, both.
And, yes... the copy of...
June 27, 2008 at 11:56 am
To answer such a general question, I have to say lookup the following in Books Online...
Bulk Insert
BCP
BCP Format Files
Linked Servers (for text files)
OpenRowSet
DTS
SSIS
OSQL
SQLCMD
June 27, 2008 at 11:52 am
Viewing 15 posts - 49,561 through 49,575 (of 59,078 total)