• If you Binoogle Itzik Ben-Gan gaps and islands TSQL all of the top hits are relevant to your need.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service