• It might be useful for you to read:

    Title: Finding Gaps in a Sequential Number Sequence

    http://www.sqlservercentral.com/Forums/Topic267061-176-2.aspx#bm1135582

    And pay particular attention to the comments on the article by Jeff Moden, and all the additional contributors in the discussion of the article

    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]