@jeff

Here is a little stored procedure i made out of this that will return a list of gaps including missing 1-x (or 0-x or whatever-x) or

return the first available...

Here is another thing i found and modified a little.

Takes under a second for 1 millon rows and returns gaps size sorted 😉

Change tables and fields surrounded by []

----------------------------------------

SELECT

...

Mike Arney (4/3/2006)

If you just need to identify IF a list of numbers is in sequence, but not where the gaps are, I believe you can do it in a...