query to check that which sequence is missing
515228Aug 6 2007 — edited Sep 25 2007Hi all,
hope all of you are fine.
plz guide me in writing auery so that i can check that which sequence is missing...
for example i have a column in which i generated the auto no with sequence
like 3501,3502,3503....................
later user can delete the record....
Now i want to check that which of the sequence is breaked like
3501,3502,3504.........now 3503 is missing........I want to check all that are missing from sequence.......
Hope you understand what i want to say
thanks in advance
Shayan
coolmaxi82@hotmail.com