Merging Results from Multiple Columns into One: A SQL Server 2012 Solution Using UNION ALL and COALESCE

Combining Column Output by Comma Separated Values in SQL Server

How to Use UNION ALL with Implicit Data Type Conversions in SQL Server

Understanding the Performance Bottleneck of a Simple SELECT Query: How Indexing Can Improve Query Performance

Alternative Approaches to Pivoting Row Data in SQL Server 2012 without Using the Pivot Function