Using UNION with Common Table Expressions in SQL Server 2014 Developer: Workarounds and Best Practices

How to Use SQL Union to Combine Queries with Different Number of Rows