[dbo].[Forum_EmailQueue_TaskEmailsGetIncomplete]

(local) > DotNetNuke_Community > Stored Procedures > dbo.Forum_EmailQueue_TaskEmailsGetIncomplete

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@EmailQueueID	int	4

SQL Script

CREATE PROCEDURE dbo.[Forum_EmailQueue_TaskEmailsGetIncomplete]
@EmailQueueID int
AS

DECLARE @@RemainingEmails int

SET @@RemainingEmails = (
SELECT
    Count(EmailQueueID)
FROM
    dbo.Forum_EmailQueue_TaskEmails
WHERE
    IsComplete = 0
AND
    EmailQueueID = @EmailQueueID
)

IF @@RemainingEmails > 0
BEGIN
SELECT (1)
END
ELSE
BEGIN
SELECT (0)
END

GO

Uses

[dbo].[Forum_EmailQueue_TaskEmails]
dbo