Mass Updation of Records

[satyajit911]

Hello,

I have to mass update 40000 records using SQL. But, this operation locks the table for some while. Can anyone suggest how I can update these records part by part say 500 records at a time.

Thanks,
Satya.

[docdiesel]

Hi,

programming a loop externally, each time you could sort the resultset and add a "fetch first 500 rows" after your conditions. But you have to make sure that those 500 won't be on top of the list the next time.

More information about your tables and sql statements could help us to help you.

Regards

Doc Diesel