UFN_PATTERNBLOCK_GETPATTERNBLOCKMEETINGS

            CREATE function dbo.UFN_PATTERNBLOCK_GETPATTERNBLOCKMEETINGS( @PATTERNBLOCKID uniqueidentifier )
            returns table
            as return(

                select 
                    PATTERNBLOCKMEETING.ID,
                    TIMETABLEDAYID,
                    PATTERNBLOCKMEETING.DESCRIPTION,
                    STARTTIME,
                    ENDTIME,
                    TIMETABLEDAYPERIODID,
                    LENGTHINPERIODS, 
                    SEQUENCE
                from 
                    dbo.PATTERNBLOCKMEETING
                join TIMETABLEDAY 
                    on TIMETABLEDAY.ID = PATTERNBLOCKMEETING.TIMETABLEDAYID
                join CYCLEDAY
                    on CYCLEDAY.ID = TIMETABLEDAY.CYCLEDAYID  
                where 
                    PATTERNBLOCKID = @PATTERNBLOCKID)