Viewing post 1 (of 1 total)
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
April 3, 2006 at 9:07 am
#630441