USP_SIMPLEDATALIST_MATCHCODE_DESCRIPTIONS

This simple datalist returns all match code descriptions prefixed by the match code.

Parameters

Parameter	Parameter Type	Mode	Description
@INCLUDECODE	bit	IN

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_MATCHCODE_DESCRIPTIONS(@INCLUDECODE bit = 1)
            as
                set nocount on;
                select 
                    MATCHCODE.[ID] as VALUE,
          case when coalesce(@INCLUDECODE, 1) = 1 then MATCHCODE.[MATCHCODE] + ' - ' 
          else '' end + MATCHCODE.[DESCRIPTION]  as LABEL
                from
                    dbo.[MATCHCODE]
                order by LABEL