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

5 Ways to Order Tables Differently with Union Clauses in SQL