UFN_CLASS_GETFACULTYSTRING_LASTNAMEFIRST

CREATE function dbo.UFN_CLASS_GETFACULTYSTRING_LASTNAMEFIRST
(
    @CLASSID uniqueidentifier
)
returns nvarchar(1000)
with execute as caller
as begin
    return (select stuff((select '; ' + CONSTITUENT.KEYNAME +
                case when CONSTITUENT.FIRSTNAME is null or CONSTITUENT.FIRSTNAME = ''
                    then ''
                    else ', ' + CONSTITUENT.FIRSTNAME
                end
            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.KEYNAME, CONSTITUENT.FIRSTNAME
            order by CONSTITUENT.KEYNAME, CONSTITUENT.FIRSTNAME asc
            for xml path(''), type).value('.', 'nvarchar(max)'), 1, 2, ''))
 end