UFN_TIMETABLEDAY_CYCLEDAY_VALID

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

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN
@CYCLEDAYID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_TIMETABLEDAY_CYCLEDAY_VALID
            (
              @ID uniqueidentifier,
              @CYCLEDAYID uniqueidentifier
            )
            returns BIT
            as begin
                if exists(select TIMETABLEDAY.ID from dbo.TIMETABLEDAY
                inner join TIMETABLE on TIMETABLE.ID = TIMETABLEDAY.TIMETABLEID
                inner join CYCLEDAY on CYCLEDAY.ID = TIMETABLEDAY.CYCLEDAYID
                    where CYCLEDAY.CYCLEID = TIMETABLE.CYCLEID
                          and TIMETABLEDAY.ID = @ID)
                    return 1;             
                return 0;
            end