UFN_MEMBERSHIPPROMO_GETCODES

Get the promo codes related to a membership promotion

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@MEMBERSHIPPROMOID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_MEMBERSHIPPROMO_GETCODES(@MEMBERSHIPPROMOID uniqueidentifier)
returns table
as return
    select
        ID,
        PROMOTIONALCODE,
        VALIDFROM,
        VALIDTO,
        SEQUENCE
    from
        dbo.MEMBERSHIPPROMOCODE
    where
        MEMBERSHIPPROMOID=@MEMBERSHIPPROMOID;