Tags / gaps-and-islands
SQL Ranking Based on Condition
Combining Duplicate Records Based on Column Combinations: A SQL Approach
Running Totals from Consecutive Columns: A Flexible Approach to Gaps and Islands
Optimizing Complex SQL Queries: A Deep Dive into Window Functions and Pattern Matching
Merging Overlapping Date Ranges in SQL Server 2014