Deleting Duplicated Rows Using Common Table Expressions (CTE) in SQL Server

Retrieving Data from Multiple Tables: A Simple yet Effective Solution Using Inner Joins

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

How to Retrieve Up-to-Date Non-Null Values from Columns with Missing Data Using COALESCE Functions.