Conditional JOINS in Microsoft T-SQL

If you have used Microsoft T-SQL at all you have undoubtedly used JOINS to connect multiple tables based on a common key value. You have probably also used the CASE statement functionality in your SELECT to conditionally change the output based on a set of parameters....