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

Optimizing Grouping on Converted Date Columns in TSQL: A Step-by-Step Guide

Grouping SQL Query by Each n Minutes Using Read-Only Access Without Joins or Subqueries