USP_DATALIST_MEMBERSHIPPROMOCODE

List the promo codes for a membership promotion.

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_MEMBERSHIPPROMOCODE(@CONTEXTID uniqueidentifier)
as
    set nocount on;

    select ID,                                                    
        PROMOTIONALCODE,
        VALIDFROM,
        VALIDTO
    from dbo.MEMBERSHIPPROMOCODE
    where MEMBERSHIPPROMOID = @CONTEXTID
    order by SEQUENCE;