Funny, I was actually glad to get this one wrong!  I had always assumed that there was no order of logical precedence and therefore always preached using parenthesis correctly.  I...

I totally believe in paying it forward.  Because of a presentation I saw in a user group, it open my eyes to a whole new world.  Actually, there wasn't a...

Ignoring the missing OVER() clause, this is still a good example.  I have seen way too many situations where DISTINCT was thrown into a query without regard to the consequences. ...

Good comments Steve.  I'd say that they worst scenario I was in where I really had to muddle through was to support an antiquated phone system.  It was a proprietary...

I have to agree with Jeff Moden on the need for better T-SQL skills especially to think and work in sets of data -- not in a procedural fashion.  I'm...

Thanks for all the replies.  I did find a solution that suited my needs.  I still generate a separate select statement for each column (I may look at the unpivot...

Oh silly me! I was so focused on the whole principle that order is not guaranteed without an ORDER BY clause that I didn’t notice the use of SET instead...