UFN_STUDENTCURRENTGRADELEVEL_GETNAME

Get the name of a student's current or future grade level

Return

Return Type
nvarchar(200)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



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

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

            return @GradeList;
        end