Hi
I still find I need Cursors when Sending out batches of Email notifications from the Server.
For example:
1. A scheduled Job selects records of people who need to be informed of some activity that has occurred - relevant data such as their email address, Name, the description of the activity etc is stored in variables using a CURSOR.
2. Inside the while loop I merge the data from the variables into an HTML Email template, and then send it out using dbMail.
I would love to replace this with set based handling but I can imagine how...particulary step 2
Adam