Re: renumbering the data in a column?

From: <>
Date: Thu, 15 Jan 2009 23:39:17 GMT
Message-ID: <FOPbl.14343$>

Mark D Powell <> wrote:
> On Jan 14, 4:00 pm, ddf <> wrote:
> > You may need to modify the code for your actual data, but it,
> > hopefully, gives you a push in the right direction.

Thanks David, just what I needed!

> Mark, David's plan is fine providing the sequence is not a PK or UK
> referenced by a FK constraint, but why do you need to re-number the
> sequence column? If the sequence field is a key then generated key
> values are arbitrary in nature and gaps should not matter. The reason
> I am asking has more to do with how the value will be handled going
> forward rather than the 'fix' being made.

Ah, I should have explained that part. It's part of our film processing system, the seq is actually a queue position. So it's an easy way to bump an emergency job to the front of the queue.

It's a PK, but processed items are deleted from the system so there's always a gap at the front..


Mark Harrison
Pixar Animation Studios
Received on Thu Jan 15 2009 - 17:39:17 CST

Original text of this message