UFN_REVENUE_GIFTFEE_CHANGED

CREATE function dbo.UFN_REVENUE_GIFTFEE_CHANGED(@REVENUEID uniqueidentifier, @GIFTFEES xml)
returns bit
as

begin;

    declare @r int;

    select @r = count(*)
    from dbo.UFN_REVENUE_GETGIFTFEES_2_FROMITEMLISTXML(@GIFTFEES) FEES
    left outer join dbo.REVENUESPLITGIFTFEE
        on FEES.ID = REVENUESPLITGIFTFEE.ID
    where REVENUESPLITGIFTFEE.ID is null or
        FEES.FEE <> REVENUESPLITGIFTFEE.FEE or
        FEES.TRANSACTIONFEE <> REVENUESPLITGIFTFEE.TRANSACTIONAMOUNT or
        FEES.WAIVED <> REVENUESPLITGIFTFEE.WAIVED

    if @r > 0
        return 1;

    return 0;

end