USP_SIMPLEDATALIST_DAILYSALES_DAILYADMISSIONPROGRAM

            create procedure dbo.USP_SIMPLEDATALIST_DAILYSALES_DAILYADMISSIONPROGRAM as

                declare @DAILYSALESMETHODID uniqueidentifier
                select 
                    @DAILYSALESMETHODID = ID 
                from dbo.SALESMETHOD
                where TYPECODE = 0

                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 = @DAILYSALESMETHODID
                order by NAME