USP_DATALIST_TIMETABLEDAY

Shows all of the days for a given timetable.

Parameters

Parameter	Parameter Type	Mode	Description
@TIMETABLEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@CYCLEDAYID	uniqueidentifier	IN	Day

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_TIMETABLEDAY
                    (
                        @TIMETABLEID uniqueidentifier,
                        @CYCLEDAYID uniqueidentifier = null
                    )
                as
                    set nocount on;

                    select TIMETABLEDAY.ID,
                                 TIMETABLEDAYPERIOD.PERIOD,
                                 CYCLEDAY.DESCRIPTION DAY,
                                 TIMETABLEDAYPERIOD.STARTTIME,
                                 TIMETABLEDAYPERIOD.ENDTIME,
                                 SEQUENCE
                    from dbo.TIMETABLEDAYPERIOD
                    inner join TIMETABLEDAY on TIMETABLEDAY.ID = TIMETABLEDAYPERIOD.TIMETABLEDAYID
                    inner join TIMETABLE on TIMETABLE.ID = TIMETABLEDAY.TIMETABLEID
                    inner join CYCLEDAY on CYCLEDAY.ID = TIMETABLEDAY.CYCLEDAYID
                    where ((@CYCLEDAYID is null) or (CYCLEDAY.ID = @CYCLEDAYID))
                    and TIMETABLE.ID = @TIMETABLEID
                    order by SEQUENCE, STARTTIME