UFN_GETBBDMEMAILLISTRECEIPIENTSCOUNT

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@EmailId	int	IN

Definition

Copy



CREATE function dbo.UFN_GETBBDMEMAILLISTRECEIPIENTSCOUNT(@EmailId as int)   
RETURNS int   
AS 
begin        
    Declare @totalReceipients as int  =0
    declare @FirstJobID int
    SELECT TOP 1 @FirstJobID=[ID]
    FROM EmailJob
    WHERE EmailID = @EmailID
    ORDER BY ID ASC

    SELECT 
        @totalReceipients    = SUM(j.NumberRequested)
    FROM EmailJob j  with (nolock)
    WHERE j.ID = @FirstJobID
    AND j.Status IN (4,5,6,7)

    if @@rowcount = 1
    BEGIN

        SELECT 
            @totalReceipients    = @totalReceipients + ISNULL(SUM(j.NumberRequested), 0)
        FROM EmailJob j  with (nolock)
        WHERE j.ConditionalParentJobID = @FirstJobID
        AND j.Status IN (4,5,6,7)
    END
    return @totalReceipients
End