USP_DATALIST_PATTERNBLOCK

                CREATE procedure dbo.USP_DATALIST_PATTERNBLOCK
                    (
                        @PATTERNID uniqueidentifier
                    )
                as
                    set nocount on;

                    select PATTERNBLOCK.ID,
                                 PATTERNBLOCK.NAME,
                                 CYCLEDAY.DESCRIPTION DAY,
                                 PATTERNBLOCKMEETING.DESCRIPTION,
                                 PATTERNBLOCKMEETING.STARTTIME,
                                 PATTERNBLOCKMEETING.ENDTIME,
                                 TIMETABLEDAYPERIOD.PERIOD,
                                 case when PATTERNBLOCKMEETING.LENGTHINPERIODS = 0 then '' else cast(PATTERNBLOCKMEETING.LENGTHINPERIODS as varchar(10)) end,
                                 SEQUENCE
                    from dbo.PATTERNBLOCKMEETING
                    inner join PATTERNBLOCK on PATTERNBLOCK.ID = PATTERNBLOCKMEETING.PATTERNBLOCKID
                    inner join PATTERN on PATTERN.ID = PATTERNBLOCK.PATTERNID
                    inner join TIMETABLEDAY on TIMETABLEDAY.ID = PATTERNBLOCKMEETING.TIMETABLEDAYID
                    left join TIMETABLEDAYPERIOD on TIMETABLEDAYPERIOD.ID = PATTERNBLOCKMEETING.TIMETABLEDAYPERIODID
                    inner join CYCLEDAY on CYCLEDAY.ID = TIMETABLEDAY.CYCLEDAYID
                    where PATTERN.ID = @PATTERNID
                    order by SEQUENCE, STARTTIME