UFN_TERM_CYCLEDAY_VALID

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

Return

Return Type
bit

Parameters

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

Definition

Copy



            create function dbo.UFN_TERM_CYCLEDAY_VALID
            (
              @ID uniqueidentifier,
              @CYCLEDAYID 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.CYCLEDAYID = @CYCLEDAYID)
                    return 1;             
                return 0;
            end