Thanks Noel, but I wanted to be able to do just a set of row, say 10,000 or

100,000 at a time. How do i do it so that the query will continue to the next

10K or 100k records, without using cursor. if i do rowcount or top of 10,0000, it would only running once for only those records that set, right?