USP_DATALIST_DISCOUNTGROUPSIZE

Displays a list of discount group sizes by specific value.

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_DISCOUNTGROUPSIZE
                (
                    @DISCOUNTID uniqueidentifier
                )
                as
                    set nocount on;

                    select
                        [ID],
                        [GROUPSIZE],
                        [AMOUNT] as [SPECIFICPRICE]
                    from dbo.[GROUPSIZEDISCOUNT]
                    where [DISCOUNTID] = @DISCOUNTID
                    order by [GROUPSIZE];

                    return 0;