UFN_CREDITITEMMEMBERSHIP_MEMBERSHIPDISPLAY

Used to get text membership descriptions for a refunded membership transaction.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_CREDITITEMMEMBERSHIP_MEMBERSHIPDISPLAY(@ID uniqueidentifier)
returns table
as return (
    select
        CREDITITEMMEMBERSHIP.MEMBERSHIPPROGRAMNAME + ' - ' + MEMBERSHIPLEVEL.NAME + ' (' + MEMBERSHIPLEVELTERM.TERM + ')' as DISPLAY
    from
        dbo.CREDITITEMMEMBERSHIP
    inner join
        dbo.MEMBERSHIPLEVEL on MEMBERSHIPLEVEL.ID = CREDITITEMMEMBERSHIP.MEMBERSHIPLEVELID
    inner join
        dbo.MEMBERSHIPLEVELTERM on MEMBERSHIPLEVELTERM.ID = CREDITITEMMEMBERSHIP.MEMBERSHIPLEVELTERMID
    where
        CREDITITEMMEMBERSHIP.ID = @ID
)