Grouping Table Rows Together with a Unique Identifier in SQL Server 2008

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