UFN_CLASS_GETFACULTYSTRING

CREATE function dbo.UFN_CLASS_GETFACULTYSTRING
(
    @CLASSID uniqueidentifier
)
returns nvarchar(1000)
with execute as caller
as begin
    return (select stuff((select '; ' + CONSTITUENT.NAME
            from dbo.CLASSMEETINGGROUP
                inner join dbo.FACULTYCLASSMEETINGGROUP on CLASSMEETINGGROUP.ID = FACULTYCLASSMEETINGGROUP.CLASSMEETINGGROUPID
                inner join dbo.FACULTYCOURSE on FACULTYCLASSMEETINGGROUP.FACULTYCOURSEID = FACULTYCOURSE.ID
                inner join dbo.CONSTITUENT on FACULTYCOURSE.FACULTYID = CONSTITUENT.ID
            where CLASSMEETINGGROUP.CLASSID = @CLASSID
            group by CONSTITUENT.ID, CONSTITUENT.NAME
            order by CONSTITUENT.NAME asc
            for xml path(''), type).value('.', 'nvarchar(max)'), 1, 2, ''))
end