UFN_MEMBERSHIPTRANSACTION_GETBYPROGRAM_TOTABLE

Gets a temporary table of all transactions related to a given Membership Program

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@MEMBERSHIPPROGRAMID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_MEMBERSHIPTRANSACTION_GETBYPROGRAM_TOTABLE 
(
    @MEMBERSHIPPROGRAMID uniqueidentifier
) 
returns table
as
    return select
        MEMBERSHIPTRANSACTION.ID,
        MEMBERSHIPTRANSACTION.ACTIONCODE,
        MEMBERSHIP.ID as MEMBERSHIPID,
        MEMBERSHIPTRANSACTION.TRANSACTIONDATE,
        MEMBERSHIPTRANSACTION.EXPIRATIONDATE
    from dbo.MEMBERSHIPTRANSACTION
        inner join dbo.MEMBERSHIP on MEMBERSHIPTRANSACTION.MEMBERSHIPID = MEMBERSHIP.ID
    where
        MEMBERSHIP.MEMBERSHIPPROGRAMID = @MEMBERSHIPPROGRAMID;