fnFundRaiserEmail_RecipientByTeamID

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@TeamID	int	IN

Definition

Copy


            CREATE  FUNCTION [dbo].[fnFundRaiserEmail_RecipientByTeamID]
            (@TeamID int) 
            returns int
            as 
            begin
            return (
                SELECT 
                ISNULL(count(recip.id),0)
                FROM
                dbo.fnFundRaiserTeamSolicitors(@TeamID, 0, 0) Solicitor
                inner join dbo.FundraiserSolicitorEmail FREmail on Solicitor.SolicitorID = FREmail.FundRaiserSolicitorsID
                inner join dbo.EmailJob on FREmail.EmailJobID = EmailJob.ID
                inner join dbo.Email_Recipient recip on EmailJob.EmailID = recip.EmailID

            )
            end