I have an update statement that is running on a table. I have given a small example of it below.
The problem I have is that there are 448653 records.
Basically I want to add some sort of loop that will commit the update every 500 records rather than doing them all at the same time.
Can someone give me some advice.
ModifiedDate = GETDATE(),
ModifiedBy = 808
Customer c (NOLOCK)
INNER JOIN Prospect p (NOLOCK)
ON c.CustomerId = p.CustomerId