UFN_RECURRINGGIFT_GETTOTALPAIDIGNOREPAYMENT

Returns the total amount paid to the given recurring gift, ignoring the given payment.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode	Description
@RECURRINGID	uniqueidentifier	IN
@PAYMENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_RECURRINGGIFT_GETTOTALPAIDIGNOREPAYMENT
            (
                @RECURRINGID uniqueidentifier,
                @PAYMENTID uniqueidentifier
            ) 
            returns money
            with execute as caller
            as begin
                declare @RESULT money;

                select 
                    @RESULT = sum(RECURRINGGIFTACTIVITY.AMOUNT)
                from dbo.RECURRINGGIFTACTIVITY
                    inner join dbo.REVENUESPLIT on REVENUESPLIT.ID = RECURRINGGIFTACTIVITY.PAYMENTREVENUEID
                where RECURRINGGIFTACTIVITY.SOURCEREVENUEID = @RECURRINGID
                    and REVENUESPLIT.REVENUEID <> @PAYMENTID

                return @RESULT;
            end