USP_SIMPLEDATALIST_TIMETABLEDAYPERIOD_BYTIMETABLE_BYCYCLE

                create procedure dbo.USP_SIMPLEDATALIST_TIMETABLEDAYPERIOD_BYTIMETABLE_BYCYCLE
                (
                    @TIMETABLEID uniqueidentifier,
                    @CYCLEDAYID uniqueidentifier                    
                )

                as
                select
                    TIMETABLEDAYPERIOD.ID as VALUE, 
                    TIMETABLEDAYPERIOD.PERIOD as LABEL                
                from dbo.TIMETABLEDAYPERIOD
                    inner join TIMETABLEDAY on TIMETABLEDAY.ID = TIMETABLEDAYPERIOD.TIMETABLEDAYID
                where TIMETABLEDAY.TIMETABLEID = @TIMETABLEID
                    and TIMETABLEDAY.CYCLEDAYID = @CYCLEDAYID 
                order by TIMETABLEDAYPERIOD.STARTTIME