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

Comparing Two Identical Tables: Matching and Non-Matching Rows in SQL

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

Optimizing SQL Server Querying for Data Subset Retrieval