Hi, Here's the SQL code: Select LastSeqNumber , NextSeqNumber , FirstAvailable = LastSeqNumber + 1 , LastAvailable = NextSeqNumber - 1 , NumbersAvailable = NextSeqNumber - (LastSeqNumber + 1) from ( Select LastSeqNumber = (Select isnull(Max(Seq2.SeqNumber),0) as SeqNumber from #SequenceTable Seq2 where Seq2.SeqNumber 1 order by LastSeqNumber Thanks.
Read More...