fnFundRaiserUnthankedDonations

            CREATE FUNCTION [dbo].[fnFundRaiserUnthankedDonations]

            (
            @FundRaiserSolicitorID int
            )
            RETURNS int
            AS

            BEGIN
            RETURN(
            SELECT
            count(donation.id)
            FROM
            dbo.FundRaiserDonations donation
            INNER JOIN dbo.DonationTransactions donationTran 
            on 
            donation.DonationTransactionsID = donationTran.DonationTransactionsID
            WHERE
            donation.ThankedDate IS NULL
            and
            donation.SolicitorID = @FundRaiserSolicitorID
            and
            donation.IsChangeBucket = 0
            and
            donationTran.IsDeleted = 0
            )

            END