USP_SIMPLEDATALIST_PROGRAM_SALES

            create procedure dbo.USP_SIMPLEDATALIST_PROGRAM_SALES(
                    @TYPECODE tinyint
                ) as
                    select PROGRAM.ID as VALUE,
                        PROGRAM.NAME as LABEL
                    from dbo.PROGRAM
                    inner join dbo.EVENT on EVENT.PROGRAMID = PROGRAM.ID
                    inner join dbo.EVENTSALESMETHOD on EVENT.ID = EVENTSALESMETHOD.EVENTID
                    inner join dbo.SALESMETHOD on EVENTSALESMETHOD.SALESMETHODID = SALESMETHOD.ID
                    where SALESMETHOD.TYPECODE = @TYPECODE
                    group by PROGRAM.ID, PROGRAM.NAME