UFN_PATTERNBLOCKMEETING_TIMETABLEDAYPERIOD_VALID

Check to see if the period is valid for the given day

Return

Return Type
bit

Parameters

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

Definition

Copy



            CREATE function dbo.UFN_PATTERNBLOCKMEETING_TIMETABLEDAYPERIOD_VALID
            (
              @TIMETABLEDAYID uniqueidentifier,
              @TIMETABLEDAYPERIODID uniqueidentifier
            )
            returns BIT
            as begin
                if exists(select TIMETABLEDAY.ID from dbo.TIMETABLEDAY 
                inner join TIMETABLEDAYPERIOD on TIMETABLEDAYPERIOD.TIMETABLEDAYID = TIMETABLEDAY.ID
                    where TIMETABLEDAY.ID = @TIMETABLEDAYID
                          and TIMETABLEDAYPERIOD.ID = @TIMETABLEDAYPERIODID)
                    return 1;             
                return 0;
            end