How to Calculate Running Total of "Due" Jobs in SQL Server 2012: Recursive Queries and Cursors Compared

Creating Time Windows with Alternating Values in T-SQL

Dynamic Unpivoting: A Guide to Transforming Tables with Columns of Different Types

Concatenating Distinct Values with PostgreSQL's STRING_AGG and "Distinct On