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