Viewing 15 posts - 1,081 through 1,095 (of 4,080 total)
You can also create a table variable which can hold multiple rows and may be passed as a parameter.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 16, 2011 at 12:56 pm
jcrawf02 (6/16/2011)
"You HAVE to click this link …. It is a video name generator and gives you new (made up)...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 16, 2011 at 12:39 pm
The execution plan comes out the same whether or not you use TOP (0) or Where 1 = 0.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 16, 2011 at 8:41 am
In this respect, the OUTPUT clause is your friend.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 16, 2011 at 8:34 am
It's not a strictly ASCII sort. SQL can and will treat "C" and "c" as equivalents.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 16, 2011 at 8:17 am
I'm shocked that I didn't have at least 1000 posts, but at least I'm still in the top 10. 😛
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 15, 2011 at 4:06 pm
Way to go, Grant.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 15, 2011 at 7:16 am
So... which exam are you cheating on ?? 😛
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 14, 2011 at 9:21 pm
steve conard (6/14/2011)
Found...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 14, 2011 at 7:20 am
Break the 300k file script file into 10 files of 30k apiece, being sure to break between insert statements. Then just run them sequentially.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 13, 2011 at 3:57 pm
Jack Corbett (6/13/2011)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 13, 2011 at 3:42 pm
The best way to deal with these types of problems is with a calendar table. I would advise you to create a permanent one for future use,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 13, 2011 at 1:00 pm
SQL doesn't truly provide array capability, although it is quite good at applying operations against entire sets of data. Think of it as having the WHILE loop done...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 13, 2011 at 12:34 pm
Good point, Tom.
I was thinking that "certifiable" might be more appropriate than "certified".
--------------------
Bob Hovious TCP/RUHOR (released under his own recognizance)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 13, 2011 at 11:40 am
I get to Nashville several times a year. Can I share in a couple?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 13, 2011 at 10:28 am
Viewing 15 posts - 1,081 through 1,095 (of 4,080 total)