UFN_DISCOUNT_GETPROMOTIONALCODES

This function returns a discount's promotion codes given its ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@DISCOUNTID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_DISCOUNT_GETPROMOTIONALCODES
    (
      @DISCOUNTID uniqueidentifier
    )
        returns table
        as return
            select
                ID,
        PROMOTIONALCODE,
        VALIDFROM,
        VALIDTO,
        SEQUENCE
            from
                dbo.PROMOTIONALCODE
            where
                DISCOUNTID=@DISCOUNTID;