UFN_MEMBERSHIPSALESACTIONCODE

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@MEMBERSHIPPROGRAMID	uniqueidentifier	IN
@PREVIOUSMEMBERSHIPLEVELID	uniqueidentifier	IN
@PREVIOUSEXPIRATIONDATE	datetime	IN
@PREVIOUSACTIONCODE	tinyint	IN
@TRANSACTIONDATE	datetime	IN

Definition

Copy



create function dbo.UFN_MEMBERSHIPSALESACTIONCODE
(
    @MEMBERSHIPPROGRAMID uniqueidentifier,
    @PREVIOUSMEMBERSHIPLEVELID uniqueidentifier,
    @PREVIOUSEXPIRATIONDATE datetime,
    @PREVIOUSACTIONCODE tinyint,
    @TRANSACTIONDATE datetime
)
returns @ACTIONCODES table (
    MEMBERSHIPLEVELID uniqueidentifier,
    ACTIONCODE tinyint
)
with execute as caller
as begin    
    insert into @ACTIONCODES
    (
        MEMBERSHIPLEVELID,
        ACTIONCODE
    )
    (
        select
            MEMBERSHIPLEVEL.ID,
            dbo.UFN_MEMBERSHIPTRANSACTION_DETERMINENEWACTIONCODE(@PREVIOUSMEMBERSHIPLEVELID, @PREVIOUSEXPIRATIONDATE, @PREVIOUSACTIONCODE, MEMBERSHIPLEVEL.ID, @TRANSACTIONDATE) as ACTIONCODE
        from
            dbo.MEMBERSHIPPROGRAM
        inner join
            dbo.MEMBERSHIPLEVEL on MEMBERSHIPLEVEL.MEMBERSHIPPROGRAMID = MEMBERSHIPPROGRAM.ID
        where
            MEMBERSHIPPROGRAM.ID = @MEMBERSHIPPROGRAMID
    );

    return;
end