fnFundraiserAddressbookContactsTotalRaised

CREATE FUNCTION [dbo].[fnFundraiserAddressbookContactsTotalRaised]
    (
    @AddressbookContactsID int
    )
    RETURNS money
    AS
    BEGIN
    RETURN
    (
    SELECT isnull(sum(Amount),0) FROM
    dbo.FundraiserSolicitorContactAction ca
    INNER JOIN dbo.FundRaiserDonations d ON d.ID = ca.FundRaiserDonationsID
    INNER JOIN dbo.DonationTransactions dt ON dt.DonationTransactionsID = d.DonationTransactionsID
    WHERE 
    ca.AddressbookContactsID = @AddressbookContactsID AND
    dt.isDeleted = 0 AND
    dt.Status = 1 AND
    dt.Processed_date IS NOT NULL
    )
    END