Merging Consecutive Time Records in SQL Server 2008: A New Approach Using Pseudo Groups and Grouping

Resetting Row Numbers Every Two Hours in SQL Using Window Functions

Categorizing Result Sets with RowNumber: A Deep Dive into SQL Server Techniques and Alternatives