UFN_MEMBERSHIP_LATESTTRANSACTIONASOF

CREATE function dbo.UFN_MEMBERSHIP_LATESTTRANSACTIONASOF (
    @ID uniqueidentifier,
    @ASOF date = null
)
returns table
as return
    select
        ID,
        MEMBERSHIPID,
        MEMBERSHIPLEVELID,
        MEMBERSHIPLEVELTERMID,
        MEMBERSHIPLEVELTYPECODEID,
        TRANSACTIONDATE,
        EXPIRATIONDATE,
        REVENUESPLITID,
        ISGIFT,
        DONORID,
        NUMBEROFCHILDREN,
        COMMENTS,
        ACTIONCODE,
        MEMBERSHIPPROMOID
    from
        dbo.UFN_MEMBERSHIP_LATESTTRANSACTIONASOF_BULK(@ASOF)
    where
        MEMBERSHIPID = @ID