CODE EXAMPLE FOR SQL

How to concatenate text from multiple rows into a single text string in SQL Server

SELECT STRING_AGG(Name, ', ') AS Departments
FROM HumanResources.Department;