RE: Update the first 1500 records that need updating

I don't think this will work. First, I'm pretty sure that you can't have a
FETCH FIRST clause on an UPDATE statement. Second, if I read Alan's request
correctly, he doesn't want to update the first 1500 records, he wants to
update the first 1500 records which match the condition (FIELDA = 'X').

For example, let's say half the records have FIELDA = 'X'. Your suggestion
would update (approximately) 750 records, since you are processing 1500 of
which only half meet the criteria. In this specific case, Alan would
actually need to process 3000 records in order to update 1500 records.

After looking at the situation carefully, I have to say I can't see any easy
way to do it. Then again, I don't understand the "WHY" unless the issue is
simply to reduce the processing time.

Joe

From: Francis Lapeyre

Add FETCH FIRST 1500 ROWS ONLY to the statement.

On Dec 4, 2007 3:23 PM, Alan Shore <AlanShore@xxxxxxxx> wrote:

Hi everyone
(Hopefully) A quick sql question.
I have a simple SQL update
UPDATE FILEA SET FIELDA = 'N' WHERE FIELDA = 'X'

However there are thousands of records that will be updated. I only need
to update the first 1500 of these records (no other selection criteria,
just the first 1500)

Is this possible?
If so, how?