Creating Time Windows with Alternating Values in T-SQL

Creating Date Ranges from Multiple Rows Based on a Single Date

Selecting Records Where Only One Parameter Changes Using SQL and LINQ: A Deep Dive