USP_SIMPLEDATALIST_PATTERNBLOCK_TIMETABLEDAY

                CREATE procedure dbo.USP_SIMPLEDATALIST_PATTERNBLOCK_TIMETABLEDAY
                (
                    @ID uniqueidentifier = null
                )
                as
                    set nocount on;

                    select
                        TIMETABLEDAY.ID as VALUE,
                        CYCLEDAY.DESCRIPTION as LABEL
                    from dbo.PATTERNBLOCK
                        inner join dbo.PATTERNBLOCKMEETING on PATTERNBLOCK.ID = PATTERNBLOCKMEETING.PATTERNBLOCKID
                        inner join dbo.TIMETABLEDAY on PATTERNBLOCKMEETING.TIMETABLEDAYID = TIMETABLEDAY.ID
                        inner join dbo.CYCLEDAY on TIMETABLEDAY.CYCLEDAYID = CYCLEDAY.ID
                    where PATTERNBLOCK.PATTERNID = @ID
                    group by TIMETABLEDAY.ID, CYCLEDAY.DESCRIPTION, CYCLEDAY.SEQUENCE
                    order by CYCLEDAY.SEQUENCE asc