SQL 7 Identity detect missing record

[Brit]

I have a table with an identity field (Sql Server 7). I want a script to scan the table and return the record before a gap in the sequence.

(I have a gap in the sequence when a transaction failed and the inserted record is removed.)

Is it possible to do without creating a cursor to loop through the data?

thanks for your help,

Brit

 

[JohnDTampaBay]

There are several posts about resolving gaps in data. Search for gaps and check out the responses. Some solutions use a separate table that contain the complete range to be tested against (1 through 100000000 integers), while other use a more dynamic approach. I believe all posts try to avoid a cursor. --Angel
-----------------------------------
SELECT * FROM users WHERE clue > 0
(0 row(s) affected)

 

[tlbroadbent]

Don't forget to search the FAQs!

faq183-840: How Can I Find Gaps in Date and Number Sequences?
Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/programmer.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.