Kevin Rathgeber (2/18/2010)

---

Completely understand. I suspected that was the case (I could have mentioned that a little better than I did) 😀

This was more a warning for those who...

I guessing that it's because you have no table nor table alias named "tEx".

It is a myth that subqueries are necessarily a bad thing.

Dynamic SQL is not preferred, but saying that it should be "avoided at all costs" is far too strong and just is not correct. There are many, many situations...

Leon Orlov-255445 (2/18/2010)

---

Hello all,

Have anybody were successful in attempt to modify SQL Server 2008 'system stored procedure'?

Lets say that for some really insane reason you want to modify 'system stored...

Variables in T-SQL are batch-scoped. They go away when the batch that created them does. Note that stored procedures executions are batches.

(edit: improved wording to be less ambiguous)

So, should we uncomment them? Because if I leave them commented, then its not doing very much.

tstaker (2/18/2010)

---

jcrawf02 (2/18/2010)

---

Grant Fritchey (2/18/2010)

---

Oh jeez, I'm so stupid. I never even thought about that. No wonder everyone gets so many points. Here I am trying to honestly answer the...

IMHO, you should know and understand the normalization rules up to 5th Normal Form (or at least Boyce-Codd). Most "acceptable" data designs are at least 3rd Normal Form. ...

Alvin Ramard (2/17/2010)

---

RBarryYoung (2/17/2010)

---

CirquedeSQLeil (2/17/2010)

---

Has anyone noticed the success/failure rate on the QOD today?

74% incorrect for Paul Randal's question on Checksum. Numbers are similar to his question the other...

Give us the whole error message please. Also we need a version of your query that can reproduce the problem. Having "blah blahblah" in there makes it impossible...

FYI: I think that you used a [ quote ] tag in your post when you meant to use a [ code="sql" ] tag.

The Correct% always...

Why are all of the INSERTs and UPDATEs commented out?

Also, you cannot do variable assignments "bare" in T-SQL, you have to put a "SELECT " in front.

Like:

SELECT @myVariable = @someOtherVariable