USP_SIMPLEDATALIST_DISCOUNT

Gets a list of all active discounts.

Definition

Copy


                create procedure dbo.USP_SIMPLEDATALIST_DISCOUNT
                as
                    set nocount on;

                    select 
                        ID as VALUE,
                        NAME as LABEL
                    from dbo.DISCOUNT
                    where ISACTIVE = 1

                return 0;