UFN_STUDENTCURRENTHOMEROOMTEACHER_GETNAME

Get the name of a student's current homeroomteacher(s)

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_STUDENTCURRENTHOMEROOMTEACHER_GETNAME(@ID uniqueidentifier) returns nvarchar(100) 
        with execute as caller
         as begin
            declare @teachernames nvarchar(500);

            set @teachernames = ''
            select @teachernames = CASE @teachernames WHEN '' THEN dbo.CONSTITUENT.NAME ELSE @teachernames + '; ' + dbo.CONSTITUENT.NAME END
            from dbo.UFN_STUDENTPROGRESSION_CURRENTINFORMATION(@ID) as CURRENTINFO
            inner join dbo.CONSTITUENT on CURRENTINFO.HOMEROOMTEACHERID = CONSTITUENT.ID
            group by dbo.CONSTITUENT.NAME

            return @teachernames;
        end