fnFundRaiserEmail_RecipientBySolicitorID

CREATE FUNCTION dbo.fnFundRaiserEmail_RecipientBySolicitorID
(
@SolicitorID int
) 
returns int
as 
begin
return (

    SELECT count(Recip.ID)
    FROM dbo.FundraiserSolicitorEmail FREmail
    inner join dbo.EmailJob on FREmail.EmailJobID = EmailJob.ID
    inner join dbo.Email_Recipient recip on EmailJob.EmailID = recip.EmailID
    WHERE FREmail.FundRaiserSolicitorsID=@SolicitorID
)
end