UFN_MEMBERSHIP_GETRECURRINGGIFT_2

create function dbo.UFN_MEMBERSHIP_GETRECURRINGGIFT_2
(
    @MEMBERSHIPID uniqueidentifier,
    @INCLUDEINACTIVERECURRINGGIFTS bit
)
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
                        inner join REVENUESCHEDULE on FINANCIALTRANSACTION.ID = REVENUESCHEDULE.ID
                    where 
                        MEMBERSHIPTRANSACTION.MEMBERSHIPID = @MEMBERSHIPID
                        and FINANCIALTRANSACTION.TYPECODE = 2
                        and MEMBERSHIPTRANSACTION.TRANSACTIONDATE >= MEMBERSHIP.JOINDATE
                        and (@INCLUDEINACTIVERECURRINGGIFTS = 1 or REVENUESCHEDULE.STATUSCODE = 0)
                    order by 
                        MEMBERSHIPTRANSACTION.TRANSACTIONDATE desc, 
                        MEMBERSHIPTRANSACTION.DATEADDED desc)
end