UFN_TERM_TIMETABLEDAY_VALID

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

Return

Return Type
bit

Parameters

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

Definition

Copy



            create function dbo.UFN_TERM_TIMETABLEDAY_VALID
            (
              @ID uniqueidentifier,
              @TIMETABLEDAYID uniqueidentifier
            )
            returns BIT
            as begin
                if exists(select TERM.ID from dbo.TERM
                    inner join SESSION on SESSION.ID = TERM.SESSIONID 
                    inner join TIMETABLE on TIMETABLE.ID = SESSION.TIMETABLEID  
                    inner join TIMETABLEDAY on TIMETABLEDAY.TIMETABLEID = TIMETABLE.ID
                    where TERM.ID = @ID
                          and TIMETABLEDAY.ID = @TIMETABLEDAYID)
                    return 1;             
                return 0;
            end