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...

Pretty slick! It took me a moment with the multiple casts but that was a slick trick.:smooooth:

Just to reiterate what some others have stated: Consistency is King!  Like with many other programming conventions, however it's done is not really as important as long as it's done...