Missing numbers

[Saama5]

I have an smallint field which can have maximum of 6000 value.
Everytime I insert record I want to insert the next available number but not the max(field1) + 1.

Because I might be deleting some records so there would be some unused numbers between 1 - 6000 which were not allocated yet.

Is there any single command or I have to use cursor and check out the next value with previous value.

 

[SriSamp]

There is no single command to find this out.

SriSamp

 

[JohnDTampaBay]

You might check out faq183-840 which covers finding the gaps - or unused values - in a series of numbers. --Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.