USP_SIMPLEDATALIST_TIMETABLEDAY_UNDEFINED

                create procedure dbo.USP_SIMPLEDATALIST_TIMETABLEDAY_UNDEFINED
                (
                    @TIMETABLEID uniqueidentifier
                )

                as
                select 
                    DAYS.VALUE, DAYS.LABEL 
                from
                    (select 
                        CYCLEDAY.ID as VALUE, 
                        CYCLEDAY.DESCRIPTION as LABEL,
                        CYCLEDAY.SEQUENCE
                    from dbo.CYCLEDAY
                        inner join TIMETABLE on TIMETABLE.CYCLEID = CYCLEDAY.CYCLEID
                        inner join TIMETABLEDAY on TIMETABLEDAY.TIMETABLEID = TIMETABLE.ID AND CYCLEDAYID = CYCLEDAY.ID
                    where TIMETABLE.ID = @TIMETABLEID 
                        and NOT exists(select TIMETABLEDAYPERIOD.TIMETABLEDAYID 
                                    from TIMETABLEDAYPERIOD 
                                    where TIMETABLEDAYID = TIMETABLEDAY.ID)

                    union 
                        select
                            '00000000-0000-0000-0000-000000000001' as VALUE,
                            'All cycle days' as LABEL,
                            0 as SEQUENCE
                        where 
                            not exists(select TIMETABLEDAYPERIOD.TIMETABLEDAYID 
                                    from TIMETABLEDAYPERIOD
                                    inner join TIMETABLEDAY on TIMETABLEDAY.ID = TIMETABLEDAYPERIOD.TIMETABLEDAYID
                                    where TIMETABLEDAY.TIMETABLEID = @TIMETABLEID)

                    ) DAYS 
                order by SEQUENCE