fnFundRaiserSolicitorContactHasDonations

CREATE FUNCTION dbo.fnFundRaiserSolicitorContactHasDonations(@FRContactID int)
Returns bit
AS

BEGIN


    DECLARE @Result bit
    DECLARE @DonationCount int

    Set @Result = 0

    SELECT @DonationCount = Count(FRAction.ID)
    FROM
    dbo.FundRaiserSolicitorContactAction FRAction
    WHERE
    FRAction.FundraiserSolicitorContactID = @FRContactID
    and
    FRAction.Type IN (5,7,11)

    If @DonationCount > 0 

    BEGIN
        Set @Result = 1
    END

    Return @Result


END