fnFundRaiserDonationTotal

CREATE FUNCTION [dbo].[fnFundRaiserDonationTotal](    
               @FundRaiserID int
            )
                RETURNS money
            AS
                BEGIN
                    RETURN (
                        SELECT
                            isnull(sum(frdonation.amount),0)
                        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.Status = 1 and
                            donation.isDeleted = 0 and
                            Solicitor.RootFundRaiserID = @FundRaiserID
                    )
                END