Viewing 15 posts - 52,681 through 52,695 (of 59,070 total)
Fixed format files with "ragged right data" are someones idea of a cruel joke.
One way to import these is to just import into a single column table and split the...
February 1, 2008 at 5:32 pm
mike (1/27/2008)
http://www.sqlsecurity.com
Thanks, Mike.
February 1, 2008 at 5:13 pm
Heh... that's funny. Not what I intended but sure is true.
What's in the box with just a slider is a single line of code about 480 characters wide... totally...
February 1, 2008 at 11:08 am
Didn't see Kevin's latest post...
That'll be nice to have when 2k8 comes out. I thought you were saying that it's a viable 2k5 solution. Sorry for the...
February 1, 2008 at 11:02 am
TheSQLGuru (2/1/2008)
Yes, that would be the missing ORDER BY and ROWS subclauses...
February 1, 2008 at 10:57 am
TheSQLGuru (2/1/2008)
February 1, 2008 at 7:53 am
Carla Wilson (1/31/2008)
Thanks for the great examples on generating running totals. Question: You mentioned that you have to include the "anchor" (or dummy) in the update statement in...
February 1, 2008 at 7:49 am
Christian Buettner (2/1/2008)
February 1, 2008 at 7:24 am
ALZDBA (2/1/2008)
I'm very sorry to have to tell you that it fails with partitioned objects on SQL2005.
Thanks for the code, Johan... I'll check it out! And thanks for taking...
February 1, 2008 at 7:14 am
Matt Miller (1/30/2008)
January 31, 2008 at 11:16 pm
Darrin Blunt (1/31/2008)
I am curious how...
January 31, 2008 at 10:35 pm
RichardB (1/31/2008)
Run over 1.4million records on a 6 level 'hierarchy' in about 10 s - compared to the 'set' solution that takes 1.5hrs...
:exclamationmark:
Oh yes, and validation against the...
January 31, 2008 at 9:40 pm
Philippe Cand (1/31/2008)
Wether or not something is supported by Microsoft does not make it safer.
It is all about probability and bugs....
January 31, 2008 at 9:36 pm
James Goodwin (1/31/2008)
January 31, 2008 at 9:21 pm
Viewing 15 posts - 52,681 through 52,695 (of 59,070 total)