posted 23 years ago
Hi,
Thanks for reply..
By following the above approach, I've to do the following things:
1. Select all rows from database in a resultset, corresponing to the specific manager.(it can be a huge number).
2. Update each row.(first 20 rows)
Actually I want to avoid step 1, because this may involve unnecessary selection of data in the resultset.(say 5000 records are selected, out of which I want to update just first 20).
I can avoid the overhead of step 2 by sending all the queries in a batch.
Any views?
Thanks