USP_DATALIST_DISCOUNTPROGRAM

Displays a list of programs associated with a given discount.

Parameters

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

Definition

Copy



                create procedure dbo.USP_DATALIST_DISCOUNTPROGRAM
                (
                    @DISCOUNTID uniqueidentifier
                )
                as
                    set nocount on;

                    select
                        distinct PROGRAM.ID,                        
                        DG.ID as DISCOUNTGROUPID,
                        PROGRAM.NAME,
                        PROGRAM.ISACTIVE,
                        PROGRAM.DESCRIPTION                        
                    from dbo.PROGRAM
                        inner join dbo.DISCOUNTGROUPDETAILPROGRAM DGDP on PROGRAM.ID = DGDP.PROGRAMID
                        inner join dbo.DISCOUNTGROUPDETAIL DGD on DGD.ID = DGDP.ID
                        inner join dbo.DISCOUNTGROUP DG on DG.ID = DGD.DISCOUNTGROUPID
                    where DG.DISCOUNTID = @DISCOUNTID