Steve, Thank you for the easy question.

Carlo, Better luck nexk year.

I only hear this naive argument from someone that has not seen the price of server class storage. When it comes to Enterprise class systems, nothing is cheap.

Carlo Romagnano (12/23/2010)

---

Some tools (powerbuilder,qlick) replace CR and LF with space, so one line comment

in the script could alter the command.

Running the script in sql2000 I get 1,3,4 but in...

There are other ways to get points.

The only loss here is your time for what looks like a cut and...

Dietmar Weickert (12/23/2010)

---

Of course I got it wrong as probably all others trying this question. And it does not matter if you try to answer with or without SSMS.

QotD should...

stewartc-708166 (12/23/2010)

---

Having investigated this further, I have found that the "correct" answer occurs on SQL2000 and SQL2005 RTM.

this was registered as a bug and repaired with CU2 of SQL2005 (also...

Good Question... I agree that not having an order by statement can cause the output to change. I also agree that the clustered index created in the script also...

I know XML is not realy a table, but it can be used to...

You are absolutely right about that.

da-zero (12/20/2010)

---

May I ask you a question:

why is the first post in this thread...

I agree that if you read the question the answer is obvious.

However there is a HUGE typo in the explination...

B not C is the Answer?

Disapointing.

I agree Dougie....

WayneS (12/16/2010)

---

Okay, I messed up. I posted the wrong code (the posted code was run to get the error message for the QotD). Then I went and gave the explanation...

Steve - Thanks so much. You had done this...

mtillman-921105 (12/16/2010)

---

But I think the trouble comes in when you're creating different tables with the same name in different nested procedures. When you execute Select * from #test1, how...