USP_SIMPLEDATALIST_MATCHCODE_UNIQUEDESCRIPTIONS

Definition

Copy


                create procedure dbo.USP_SIMPLEDATALIST_MATCHCODE_UNIQUEDESCRIPTIONS
            as
                set nocount on;
                select 
                    min(MATCHCODE.[MATCHCODE]) as VALUE,
          MATCHCODE.[DESCRIPTION]  as LABEL
                from
                    dbo.[MATCHCODE]
        group by MATCHCODE.[DESCRIPTION]
                order by LABEL