>Let's say I have a table with 950 records. I want to select the first 100, do something, the next 100, do something, etc., then select the final 50, do something. It is the same something, I just only want to process 100 at a time.
Can you use ORDER BY and TOP clause for your processing to select 100 records? Then update some flag and select next 100 ?
If it's not broken, fix it until it is.
My Blog