Using the CASE expression instead of dynamic SQL in SQL Server

Thursday, September 13, 2012 - 10:04:19 AM - Richard Schaefer Read The Tip Your first example of using CASE to translate codes to values seems to be the least effective way to do this. The whole point of relational databases is the ability to join sets of

www.mssqltips.com