Re: Query to find first missing integer in a field
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Wed, 08 Apr 2009 09:22:11 -0500
Message-ID: <vq2Dl.24048$Ws1.15917_at_nlpi064.nbdc.sbc.com>
DeanB wrote:
> On Apr 8, 8:43 am, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
<snip>
Date: Wed, 08 Apr 2009 09:22:11 -0500
Message-ID: <vq2Dl.24048$Ws1.15917_at_nlpi064.nbdc.sbc.com>
DeanB wrote:
> On Apr 8, 8:43 am, Mark D Powell <Mark.Pow..._at_eds.com> 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.
> table inserts in a transaction will ensure referential integrity.
>
> No purge or archive process exists for these tables.
>
Received on Wed Apr 08 2009 - 09:22:11 CDT