USP_SIMPLEDATALIST_SALESMETHOD_DAILYADMISSIONPROGRAM

            create procedure dbo.USP_SIMPLEDATALIST_SALESMETHOD_DAILYADMISSIONPROGRAM
            (@SALESMETHODID uniqueidentifier = null)
            as

                select 
                    P.ID as VALUE, 
                    P.NAME as LABEL
                from dbo.PROGRAM P
                inner join dbo.PROGRAMSALESMETHOD PSM on P.ID = PSM.PROGRAMID
                where P.ISDAILYADMISSION = 1 
                and P.ISACTIVE = 1
                and PSM.SALESMETHODID = @SALESMETHODID
                order by NAME