Scott,

>How do I execute a query that shows missing ID's like so:

SELECT id AS i
FROM tbl
WHERE i <> 1 AND NOT EXISTS(
  SELECT id FROM tbl WHERE id = i - 1
);

PB

-----

Scott Hamm wrote:
If I got a table as follows:


ID foo
1 12345
2 12346
4 12348
6 12349
7 12388
9 12390
How do I execute a query that shows missing ID's like so:

3
5
8

I wouldn't expect for it to show deleted data that was deleted, just show 
the "skipped" ID's.

That way I determine if operator deleted too much (cheating at QC)

Is it possible?
  

No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.12/75 - Release Date: 8/17/2005