>Hi,
>
>I am wondering about cursors. Why would one use a cursor in SQL Server?
>Thanks
>Tim

Suppose, you need to calculate running total and you don't want to use quirky update idea. Then cursor will perform better than set based solutions.

There are few other situations where cursor performs better.

In addition, what if you need to send an e-mail? If so, you will have to use a cursor.