USP_SIMPLEDATALIST_PROGRAMPREREGISTERED

    create procedure dbo.USP_SIMPLEDATALIST_PROGRAMPREREGISTERED as
    select 
        ID as VALUE, 
        NAME as LABEL
    from dbo.PROGRAM
    where ISACTIVE = 1
        and ISPREREGISTERED = 1
    order by NAME