UFN_PATTERNBLOCKMEETING_TIMETABLEDAY_VALID

Check to see if the timetable day is valid for the given meeting

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@BLOCKID	uniqueidentifier	IN
@TIMETABLEDAYID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PATTERNBLOCKMEETING_TIMETABLEDAY_VALID
            (
              @BLOCKID uniqueidentifier,
              @TIMETABLEDAYID uniqueidentifier
            )
            returns BIT
            as begin
                if exists(select PATTERNBLOCK.ID from dbo.PATTERNBLOCK
                inner join PATTERN on PATTERN.ID = PATTERNBLOCK.PATTERNID
                inner join TIMETABLE on TIMETABLE.ID = PATTERN.TIMETABLEID
                inner join TIMETABLEDAY on TIMETABLEDAY.TIMETABLEID = TIMETABLE.ID
                    where TIMETABLEDAY.ID = @TIMETABLEDAYID
                          and PATTERNBLOCK.ID = @BLOCKID)
                    return 1;             
                return 0;
            end