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