http://www.dotnet-tricks.com/Tutorial/sqlserver/4L7I050512-SQL-Server-Basics-of-Cursors.html

Below are the steps by step approach to create a Cursor. Declare cursor Open cursor Fetch row from the cursorProcess fetched row Close cursor De-allocate cursor