UFN_STUDENTCURRENTSCHOOL_GETNAME

        CREATE function dbo.UFN_STUDENTCURRENTSCHOOL_GETNAME(@ID uniqueidentifier) returns nvarchar(200) 
        with execute as caller
         as begin
            declare @SchoolList nvarchar(max);

            select 
                @SchoolList = COALESCE(@SchoolList + '; ', '') + CURRENTINFO.[SCHOOL] 
            from 
                dbo.UFN_STUDENT_CURRENTENROLLMENTINFO(@ID, 1) as CURRENTINFO
            group by
                CURRENTINFO.[SCHOOL]

            return @SchoolList;
        end