UFN_MEMBERSHIP_GETPLEDGE

            CREATE function dbo.UFN_MEMBERSHIP_GETPLEDGE
            (
                @MEMBERSHIPID uniqueidentifier
            )
            returns uniqueidentifier
            with execute as caller
            as
            begin                
                return (select top 1 FINANCIALTRANSACTION.ID
                    from dbo.MEMBERSHIPTRANSACTION
                    inner join dbo.MEMBERSHIP on MEMBERSHIPTRANSACTION.MEMBERSHIPID = MEMBERSHIP.ID
                    inner join dbo.FINANCIALTRANSACTIONLINEITEM on MEMBERSHIPTRANSACTION.REVENUESPLITID = FINANCIALTRANSACTIONLINEITEM.ID
                    inner join dbo.FINANCIALTRANSACTION on FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = FINANCIALTRANSACTION.ID
                    where MEMBERSHIPTRANSACTION.MEMBERSHIPID = @MEMBERSHIPID
                        and FINANCIALTRANSACTION.TYPECODE = 15
                        and MEMBERSHIPTRANSACTION.TRANSACTIONDATE >= coalesce(MEMBERSHIP.LASTRENEWEDON, MEMBERSHIP.JOINDATE)
                        and FINANCIALTRANSACTION.DELETEDON is null
                        order by MEMBERSHIPTRANSACTION.TRANSACTIONDATE desc, MEMBERSHIPTRANSACTION.DATEADDED desc)
            end