fnFundRaiserSolicitorEmailJob_RecipientsByOpened

Return

Return Type
int
Parameters

Parameter	Parameter Type	Mode	Description
@SolicitorID	int	IN
@Opened	bit	IN
Definition

Copy


CREATE  FUNCTION dbo.fnFundRaiserSolicitorEmailJob_RecipientsByOpened
(
@SolicitorID int,
@Opened bit -- 0 = Not Opened, 1 = Opened
) 
returns int
as 
BEGIN

    DECLARE @Results int

    If len(@Opened) > 0 
        Begin

            If @Opened = 1
                Begin


                    SELECT @Results = count(recip.ID)
                    FROM dbo.FundraiserSolicitorEmail FREmail
                    inner join dbo.EmailJob_Recipient recip on recip.EmailJobID = FREmail.EmailJobID
                    WHERE 
                    FREmail.FundRaiserSolicitorsID = @SolicitorID 
                    AND
                    recip.opened = 1


                End
            else
                Begin

                    SELECT @Results = count(recip.ID)
                    FROM dbo.FundraiserSolicitorEmail FREmail
                    inner join dbo.EmailJob_Recipient recip on recip.EmailJobID = FREmail.EmailJobID
                    WHERE 
                    FREmail.FundRaiserSolicitorsID = @SolicitorID 
                    AND
                    recip.opened = 0        


                End
        End

    else
        Begin

            SELECT @Results = count(recip.ID)
            FROM dbo.FundraiserSolicitorEmail FREmail
            inner join dbo.EmailJob_Recipient recip on recip.EmailJobID = FREmail.EmailJobID
            WHERE 
            FREmail.FundRaiserSolicitorsID = @SolicitorID 


        End


        Return  @Results

END