UFN_CLASS_GETSTUDENTTERMSTRING

CREATE function dbo.UFN_CLASS_GETSTUDENTTERMSTRING
(
    @CLASSID uniqueidentifier,
    @STUDENTCOURSEID uniqueidentifier
)
returns nvarchar(1000)
with execute as caller
as begin
    declare @COUNT int

    declare @TERMLIST nvarchar(1000)
    select
        @TERMLIST = coalesce(@TERMLIST + '; ', '') + TERMNAMECODE.DESCRIPTION
    from dbo.STUDENTCOURSE
        inner join dbo.STUDENTCLASSMEETINGGROUP on STUDENTCOURSE.ID = STUDENTCLASSMEETINGGROUP.STUDENTCOURSEID
        inner join dbo.CLASSMEETINGGROUP on STUDENTCLASSMEETINGGROUP.CLASSMEETINGGROUPID = CLASSMEETINGGROUP.ID
        inner join dbo.CLASS on CLASS.ID = CLASSMEETINGGROUP.CLASSID
        inner join dbo.COURSE on dbo.CLASS.COURSEID = dbo.COURSE.ID
        inner join dbo.ACADEMICYEAR on COURSE.SCHOOLID = ACADEMICYEAR.SCHOOLID
        inner join dbo.SESSION on ACADEMICYEAR.ID = SESSION.ACADEMICYEARID
        inner join dbo.TERM on SESSION.ID = TERM.SESSIONID
            and TERM.STARTDATE = CLASSMEETINGGROUP.STARTDATE
            and TERM.ENDDATE = CLASSMEETINGGROUP.ENDDATE
        inner join dbo.TERMNAMECODE on TERM.TERMNAMECODEID = TERMNAMECODE.ID
    where CLASS.ID = @CLASSID and STUDENTCOURSE.ID = @STUDENTCOURSEID
        and STUDENTCLASSMEETINGGROUP.STATUSCODE = 0
    group by TERMNAMECODE.DESCRIPTION, TERM.STARTDATE
    order by TERM.STARTDATE asc

    return @TERMLIST
end