UFN_DISCOUNTAVAILABILITY_GETCONSTITUENCYCODES

This function returns discount availability constituency codes given its ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@DISCOUNTAVAILABILITYID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_DISCOUNTAVAILABILITY_GETCONSTITUENCYCODES
    (
      @DISCOUNTAVAILABILITYID uniqueidentifier
    )
        returns table
        as return
            select
                ID,
        CONSTITUENCYCODEID,        
        SEQUENCE
            from
                dbo.DISCOUNTAVAILABILITYCONSTITUENCY
            where
                DISCOUNTAVAILABILITYID=@DISCOUNTAVAILABILITYID;