CREATE PROCEDURE dbo.[Forum_EmailQueue_TaskMarkFailed]
@EmailQueueID int
AS
UPDATE
    dbo.Forum_EmailQueue_Tasks
SET
    TaskFailed = 1,
    TaskFailedCount = TaskFailedCount + 1,
    SuccessfullSendCount = (SELECT Count(DISTINCT EmailAddress) FROM dbo.Forum_EmailQueue_TaskEmails
                                WHERE EmailQueueID = @EmailQueueID AND Failed = 0),
    FailedSendCount = (SELECT Count(DISTINCT EmailAddress) FROM dbo.Forum_EmailQueue_TaskEmails
                                WHERE EmailQueueID = @EmailQueueID AND Failed = 1),
    SentEmailCount = SuccessfullSendCount + FailedSendCount
    
WHERE
    EmailQueueID = @EmailQueueID

GO