USP_SIMPLEDATALIST_PROGRAM

List the programs in the system

Definition

Copy


      create procedure dbo.USP_SIMPLEDATALIST_PROGRAM as
          select 
              ID as VALUE
              NAME as LABEL
          from dbo.PROGRAM
          where ISACTIVE = 1
          order by NAME