UFN_SESSION_INUSE

            CREATE function dbo.UFN_SESSION_INUSE(@SESSIONID uniqueidentifier)
            returns bit
            with execute as caller
            as begin

                declare @RETVAL bit = 0

                -- Check any tables that use session here first



               -- Course Grading

                if exists 
                    (select * 
                        from dbo.V_COURSEGRADING as COURSEGRADING
                            join dbo.COURSE on COURSEGRADING.COURSEID = COURSE.ID
                        where dbo.UFN_SESSION_GET_FORSCHOOL_BYDATE(COURSE.SCHOOLID, COURSEGRADING.STARTDATE, COURSEGRADING.ENDDATE) = @SESSIONID)
                    set @RETVAL = 1;

                -- Course Restrictions

                if @RETVAL = 0 and exists 
                    (select * 
                        from dbo.V_COURSERESTRICTION as COURSERESTRICTION 
                            join dbo.COURSE on COURSERESTRICTION.COURSEID = COURSE.ID
                        where dbo.UFN_SESSION_GET_FORSCHOOL_BYDATE(COURSE.SCHOOLID, COURSERESTRICTION.STARTDATE, COURSERESTRICTION.ENDDATE) = @SESSIONID)
                    set @RETVAL = 1;    

                return @RETVAL
            end