UFN_SESSION_MARKINGCOLUMNSET_INUSE

create function dbo.UFN_SESSION_MARKINGCOLUMNSET_INUSE
    (
        @SESSIONID uniqueidentifier
    )
returns bit
with execute as caller
as begin
    declare @RETVAL bit = 0

    --Course Grading Marking Columns

    if exists(
        select SESSION.ID
        from dbo.SESSION
            inner join dbo.MARKINGCOLUMNSET on SESSION.MARKINGCOLUMNSETID = MARKINGCOLUMNSET.ID
            inner join dbo.MARKINGCOLUMN on MARKINGCOLUMNSET.ID = MARKINGCOLUMN.MARKINGCOLUMNSETID
            inner join dbo.COURSEGRADINGMARKINGCOLUMN on MARKINGCOLUMN.ID = COURSEGRADINGMARKINGCOLUMN.MARKINGCOLUMNID
            inner join dbo.COURSEGRADING on COURSEGRADINGMARKINGCOLUMN.COURSEGRADINGID = COURSEGRADING.ID
            inner 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;


    return @RETVAL
end