The cursor example above produces 11114 logical reads from the database. The following snippet performs the same operation as the cursor above but through the use of a WHILE loop.

WHILE Loops Speaking of those WHILE loops and cursors: Many people find themselves writing cursors when they need to iterate through a query.