fnFundRaiserSolicitorContactTotalEmailsSent

                   CREATE   FUNCTION [dbo].[fnFundRaiserSolicitorContactTotalEmailsSent]
            (    
            @FundRaiserSolicitorContactID int
            )
            RETURNS int
            AS
            BEGIN
            RETURN 
            (
            SELECT
            COUNT(ContactAction.ID) as EmailCount
            FROM
            dbo.FundraiserSolicitorContactAction ContactAction
            WHERE
            ContactAction.FundraiserSolicitorContactID = @FundRaiserSolicitorContactID
            and
            ContactAction.Type IN (1,2,3,4,12,13,17) --all potential email types currently
            )
            END