All of which has the potential to cause performance issues for other users. Especially if that's the first solution arrived at in solving a problem. To add to his comments, if you absolutely must iterate through a result set a good alternatives to Cursors is to use table variables and iterate through the records using a WHILE loop.