List:General Discussion« Previous MessageNext Message »
From:Scott Hamm Date:August 18 2005 12:59pm
Subject:Deleted rows
View as plain text  
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:


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?
Please avoid sending me Word or PowerPoint attachments.

Deleted rowsScott Hamm18 Aug
  • Re: Deleted rowsSGreen18 Aug
  • Re: Deleted rowsPeter Brawley18 Aug
    • Re: Deleted rowsSGreen18 Aug
      • Re: Deleted rowsScott Hamm18 Aug
      • Re: Deleted rowsPeter Brawley18 Aug
RE: Deleted rowsemierzwa18 Aug