Post your actual T-SQL statement.. some one will be able to show you how to run that for a reasonable number of rows, then take a log file backup, and...

go here and print away

http://www.sqlserverspace.com/SQLServerReservedWordList.html

Now the question was a good question on the basics, I am NOT disputing that !

[rant]

http://msdn.microsoft.com/en-us/library/ms175997.aspx

From the above reference (bolding added for emphasis)

COUNT(*) returns the number of rows in a...

Be very, very careful about using ISNUMERIC .. for example, altering your input data slightly to more readily see the possible problem.

DECLARE @Codes TABLE (Code VARCHAR(100),LineNr INT)

...

+1

This might give you a view ideas of what you can do

http://msdn.microsoft.com/en-us/library/bb522489(v=sql.100).aspx

The other item I would draw to your attention. What are the terms of the purchase/lease of the...

L' Eomot Inversé (8/14/2012)

---

Lynn Pettis (8/14/2012)

---

Brandie Tarvin (8/14/2012)

---

I get ideas from the weirdest places. I keep threatening to write stories about you people and never do. Well, this debate has...

One of the things that I'm trying to learn is to write better QotD questions. It looks like most that have responded here about missing it have acknowledged not reading...

L' Eomot Inversé (8/11/2012)

---

Nice easy question to start the week with (2 days early).

I wonder if the 100% correct rate will continue when everyone sees it and starts answering on...

Rather suprised by the distribution of answers for such a basic question

From a teaching aspect this question is full filling a major QOD objective

Thanks for the question. But using answers given on Stack Overflow as support for the correct answer, is rather weak, and lame.

There is a reference on msdn to support...

The DEVELOPER edition contains all the features that the ENTERPRISE edition contains.

http://msdn.microsoft.com/en-us/library/cc645993.aspx

Is

Test01 test02 test03 test04 test05

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

State2_J State4_A ...

Back to the basics .. nice question

Sean Lange

I think the real concern is the additional administration by Steve to keep this all moving. What happens when a question does not meet the standards or there is...