USP_DATALIST_DISCOUNTCONSTITUENCY

Displays a list of allowed constituency codes for a discount.

Parameters

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

Definition

Copy



                    CREATE procedure dbo.USP_DATALIST_DISCOUNTCONSTITUENCY
                    (
                        @DISCOUNTID uniqueidentifier,
                        @INCLUDEINACTIVE bit = 0
                    )
                    as
                        set nocount on;

                        select 
                            DISCOUNTCONSTITUENCY.ID,
                            CONSTITUENCYDEFINITION.DESCRIPTION,
                            CONSTITUENCYDEFINITION.ISACTIVE
                        from 
                            dbo.DISCOUNTCONSTITUENCY
                            left join dbo.CONSTITUENCYDEFINITION on coalesce(DISCOUNTCONSTITUENCY.CONSTITUENCYSYSTEMNAMEID,DISCOUNTCONSTITUENCY.CONSTITUENCYCODEID) = CONSTITUENCYDEFINITION.ID
                        where 
                            DISCOUNTCONSTITUENCY.DISCOUNTID = @DISCOUNTID
                            and (
                                @INCLUDEINACTIVE = 1
                                or CONSTITUENCYDEFINITION.ISACTIVE = 1
                            )
                        order by 
                            DISCOUNTCONSTITUENCY.SEQUENCE;


                        return 0;