Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Stephen Lasham Finding Gaps in a Sequential Number Sequence RE: Finding Gaps in a Sequential Number Sequence

  • April 3, 2006 at 9:07 am

    #630441

    A self join solution:

    select a.SeqNumber, max(b.SeqNumber)

    from #SequenceTable a join #SequenceTable b on a.SeqNumber > b.SeqNumber

    group by a.SeqNumber

    having a.SeqNumber - max(b.SeqNumber) > 1