• Could this be the article:

    Group Islands of Contiguous Dates (SQL Spackle)

    By Jeff Moden, 2013/10/04 (first published: 2010/12/07)

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

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]