Re: Query to find first missing integer in a field

From: Palooka <>
Date: Wed, 08 Apr 2009 22:02:47 +0100
Message-ID: <Xh8Dl.272$bq4.23_at_newsfe29.ams2>

Michael Austin wrote:
> DeanB wrote:
>> On Apr 8, 8:43 am, Mark D Powell <> wrote:

> <snip>
>> Thanks. We would only re-use an empty 'slot' when inserting new data,
>> rather than trying to correct any existing records. It may be that we
>> only have 10K records, but with IDs up in the millions, like it or
>> not, some consultants complain about such things. Doing all child-

> My advice would be to get new consultants that can deal with your data.
> This is one of the most asinine request I have seen from a consultant in
> a while - and I have seen a lot of stupid requests. You have my
> permission to point them to this NG note.

I heartily concur with both you and David. What is particularly irritating is that this nonsense has been forthcoming from "consultants" for at _least_ 30 years.

Palooka Received on Wed Apr 08 2009 - 16:02:47 CDT

Original text of this message