Unless you have case sensitive collation...

You can also create a table variable which can hold multiple rows and may be passed as a parameter.

jcrawf02 (6/16/2011)

---

Found my entertainment for the forseeable future. As provided to me:

"You HAVE to click this link …. It is a video name generator and gives you new (made up)...

The execution plan comes out the same whether or not you use TOP (0) or Where 1 = 0.

In this respect, the OUTPUT clause is your friend.

It's not a strictly ASCII sort. SQL can and will treat "C" and "c" as equivalents.

I'm shocked that I didn't have at least 1000 posts, but at least I'm still in the top 10. 😛

Way to go, Grant.

So... which exam are you cheating on ?? 😛

steve conard (6/14/2011)

---

Was hoping to avoid this as it is accounting info and breaking scripts may introduce errors. Also must be replicated possibly three times prior to final conversion.

Found...

Break the 300k file script file into 10 files of 30k apiece, being sure to break between insert statements. Then just run them sequentially.

Jack Corbett (6/13/2011)

---

Haven't been on here in awhile, and haven't even tried to catch up yet. I've been packing and cleaning the last 2 weeks and tomorrow is the...

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,...

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...

Good point, Tom.

I was thinking that "certifiable" might be more appropriate than "certified".

--------------------

Bob Hovious TCP/RUHOR (released under his own recognizance)