fnFundRaiserDonationCount

            CREATE FUNCTION [dbo].[fnFundRaiserDonationCount](     
              @FundRaiserID int
            )
            RETURNS int
            AS
            BEGIN
                RETURN (
                    SELECT
                        Count(FRDonation.ID)
                    FROM
                      dbo.DonationTransactions Donation
                      inner join dbo.FundRaiserDonations FRDonation on FRDonation.DonationTransactionsID = Donation.DonationTransactionsID
                      inner join dbo.FundRaiserSolicitors Solicitor on Solicitor.ID = FRDonation.SolicitorID
                    WHERE
                        donation.isDeleted =0 and
                        [Status] = 1  and --not strictly necessary because we are joining to FRD, which can't exist unless the status is 1, but a nice sanity check
                        Solicitor.RootFundRaiserID = @FundRaiserID
                    )
            END