USP_SIMPLEDATALIST_SCHEDULEDPROGRAM

              CREATE procedure dbo.USP_SIMPLEDATALIST_SCHEDULEDPROGRAM as
                  select 
                      PROGRAM.ID as VALUE, 
                      PROGRAM.NAME as LABEL
                  from dbo.PROGRAM
                  where (PROGRAM.ISACTIVE = 1) and (PROGRAM.ISDAILYADMISSION = 0)
                  order by PROGRAM.NAME