Listing 1
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
BEGIN TRANSACTION
SELECT TOP 500 * FROM EMAIL_VIEW
WHERE EMAIL_STATUS_ID = 1 ORDER BY EMAIL_ID, USERS_ID
UPDATE EMAIL_RECIPIENTS SET EMAIL_STATUS_ID = 1 WHERE
EMAIL_RECIPIENTS_ID IN
(SELECT TOP 500 EMAIL_RECIPIENTS_ID FROM EMAIL_RECIPIENTS WHERE
EMAIL_STATUS_ID = 1 ORDER BY EMAIL_ID, USERS_ID)
COMMIT
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
Listing 2:cf_advancedemail syntax
<cf_advancedemail from="tom <tom@tompeerconsulting.com>"
to="test <test@tompeerconsulting.com>"
format="TEXT"
tempdir="C:\inetpub\mailroot\"
spooldir="C:\inetpub\mailroot\pickup\"
type="ALTERNATIVE"
mode="SILENT">
<cf_advancedemailparam contenttype="TEXT">
Text version here
</cf_advancedemailparam>
<cf_advancedemailparam name="subject" value="SUBJECT">
<html>
<head>
<title>Testing mail</title>
</head>
<body>
<p>
<b>Here's the HTML</b>
</p>
</body>
</html>
</cf_advancedemail>