sqlrus.com
T-SQL Tuesday #18 - A Better Solution | John Morehouse
A brief look on how I used a CTE to solve the need to return data from specific tables with having to use clunky 'IF' statements.