UFN_TERM_HASMEETINGS

create function dbo.UFN_TERM_HASMEETINGS(@TERMID uniqueidentifier)
returns bit
with execute as caller
as begin

    declare @RETVAL bit = 0

    select @RETVAL =
        case when exists(
            select 1
            from dbo.CLASSMEETING
                inner join dbo.CLASSMEETINGGROUP on CLASSMEETING.CLASSMEETINGGROUPID = CLASSMEETINGGROUP.ID
                inner join dbo.CLASS on CLASSMEETINGGROUP.CLASSID = CLASS.ID
                inner join dbo.COURSE on CLASS.COURSEID = COURSE.ID
                inner join dbo.SESSION on dbo.UFN_SESSION_GET_FORSCHOOL_BYDATE(COURSE.SCHOOLID, CLASS.STARTDATE, CLASS.ENDDATE) = SESSION.ID
                inner join dbo.TERM on SESSION.ID = TERM.SESSIONID
                    and CLASSMEETINGGROUP.STARTDATE >= TERM.STARTDATE
                    and CLASSMEETINGGROUP.ENDDATE <= TERM.ENDDATE
            where TERM.ID = @TERMID
        ) then 1 else 0 end

    return @RETVAL
end