Understanding Date Manipulation in SQL: A Deep Dive

Grouping Consecutive Rows with SQL Server 2008: A Efficient Approach Using Window Functions