UFN_REVENUE_GIFTFEE_CHANGED_2

            CREATE function dbo.UFN_REVENUE_GIFTFEE_CHANGED_2
            (
                @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
                    not(FEES.TRANSACTIONFEE = 0 and FEES.WAIVED = 0 and REVENUESPLITGIFTFEE.ID is null) and
                    (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