Iterate Through a Result Set by Using Transact-SQL

This article describes various methods that you can use to simulate a cursor-like FETCH-NEXT logic in a stored procedure, trigger, or Transact-SQL batch.

Read More - Register for Free Membership