I have a table keyed by an integer column. Each time I insert a row
into the table I would like to use the lowest value that does not
currently exist in the table as a key. Is there a query that will
provide me with the lowest numeric value (for a column) that does not
exist in the table?
--
Excellent! You were on the mark; I am trying to fill the holes as
records are deleted.
Thanks Igor!
On Thu, 2009-10-08 at 19:45 -0400, Igor Tandetnik wrote:
Bob Lauria bob.lau...@sbcglobal.net wrote:
I have a table keyed by an integer column. Each time I insert a row
into the table I