String Function - STUFF

SELECT   HD.GroupName,

          STUFF((SELECT distinct  '; ' + D.Name FROM HumanResources.Department D

          WHERE D.GroupName = HD.GroupName

          FOR XML PATH('')), 1, 1, '') Name_Group                    

FROM HumanResources.Department HD

GROUP BY HD.GroupName

ORDER BY HD.GroupName