UFN_MEMBERSHIPTRANSACTION_DISPLAY

Used to get descriptions of a membership at the point of a particular transaction.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_MEMBERSHIPTRANSACTION_DISPLAY(@ID uniqueidentifier)
returns table
as return (
    select
        MEMBERSHIPPROGRAM.NAME + ' - ' + MEMBERSHIPLEVEL.NAME + ' (' + MEMBERSHIPLEVELTERM.TERM + ')' as DISPLAY
    from
        dbo.MEMBERSHIPTRANSACTION
    inner join
        dbo.MEMBERSHIP on MEMBERSHIP.ID = MEMBERSHIPTRANSACTION.MEMBERSHIPID
    inner join
        dbo.MEMBERSHIPPROGRAM on MEMBERSHIPPROGRAM.ID = MEMBERSHIP.MEMBERSHIPPROGRAMID
    inner join
        dbo.MEMBERSHIPLEVEL on MEMBERSHIPLEVEL.ID = MEMBERSHIPTRANSACTION.MEMBERSHIPLEVELID
    inner join
        dbo.MEMBERSHIPLEVELTERM on MEMBERSHIPLEVELTERM.ID = MEMBERSHIPTRANSACTION.MEMBERSHIPLEVELTERMID
    where
        MEMBERSHIPTRANSACTION.ID = @ID
)