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