Couldnt read the question. Mine looked just like the screen shot earlier in the thread. Boo. 🙁

think these two QODs really show how evil implicit type conversions are.

Id rather spend this one second on explicit type conversion than on reviewing such code for possible data...

Best QoD in a while. More like this, please!

Hmm, the question seems to assume that T-SQL is the easiest way to do this. I think using Management Studio is far "easier" and faster.

Right click on...

When first glancing at the performance chart, it appears that SET NOCOUNT ON is giving a 2-3x performance increase (that would be incredible news). Its not a good idea...