UFN_MEMBERSHIP_GETLASTMEMBERSHIPTRANSACTIONID

                CREATE function dbo.UFN_MEMBERSHIP_GETLASTMEMBERSHIPTRANSACTIONID
                (
                    @ID uniqueidentifier
                )
                returns uniqueidentifier
                as begin                    
                    declare @TRANSACTIONID uniqueidentifier = null
                    select top 1 @TRANSACTIONID = [MEMBERSHIPTRANSACTION].[ID] 
                    from dbo.[MEMBERSHIPTRANSACTION] 
                    where [MEMBERSHIPTRANSACTION].[MEMBERSHIPID] = @ID
                    order by [MEMBERSHIPTRANSACTION].[TRANSACTIONDATE] desc, [MEMBERSHIPTRANSACTION].[DATEADDED] desc

                    return @TRANSACTIONID;
                end