Although it is true that you should try your best to avoid the cursor, a particular feature in any language exists because it has some usage.

See the DECLARE CURSOR Transact-SQL help in SQL Server Books Online and you will find and detailed example right at the bottom of that article.

Hope it helps.

Nitin.