USP_SIMPLEDATALIST_PROGRAM_DAILYADMISSIONADVANCESALES

            create procedure dbo.USP_SIMPLEDATALIST_PROGRAM_DAILYADMISSIONADVANCESALES as
                select 
                    P.ID as VALUE, 
                    P.NAME as LABEL
                from dbo.PROGRAM P
                inner join dbo.PROGRAMSALESMETHOD PSM on PSM.PROGRAMID = P.ID
                inner join dbo.SALESMETHOD SM on SM.ID = PSM.SALESMETHODID
                inner join dbo.PROGRAMPRICE PP on P.ID = PP.PROGRAMID
                where P.ISDAILYADMISSION = 1 and 
                    SM.TYPECODE = 1 and
                    P.ISACTIVE = 1
                group by P.ID, P.NAME
                order by NAME