USP_SIMPLEDATALIST_ALLDISCOUNTS

                CREATE procedure dbo.USP_SIMPLEDATALIST_ALLDISCOUNTS
                as
                    set nocount on;

                    select 
                        ID as VALUE,
                        NAME as LABEL
                    from dbo.DISCOUNT
                    where SUPERSEDEDBYID is null
                    order by NAME


                return 0;