USP_DATALIST_PATTERNBLOCKMEETING

Shows all of the block meetings for a given pattern.

Parameters

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

Definition

Copy



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

                    declare @TODAY date = getdate()

                    select PATTERNBLOCKMEETING.ID,
                        TIMETABLEDAY.ID as TIMETABLEDAYID,
                        @TODAY,
                        PATTERNBLOCK.NAME,
                        PATTERNBLOCKMEETING.DESCRIPTION,
                        PATTERNBLOCKMEETING.STARTTIME,
                        PATTERNBLOCKMEETING.ENDTIME,
                        PATTERNBLOCK.COLORSTYLECODE
                    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
                    where PATTERN.ID = @PATTERNID