• Here's a good reference article.

    Group Islands of Contiguous Dates (SQL Spackle)

    http://www.sqlservercentral.com/articles/T-SQL/71550/