SQL Server STUFF() function to flatten a table column

Scenario:

List Employees with their the roles.

Role
ID	Name
1	Developer
2	Manager

Employee
ID	Name
1	Terry
2	Jerry

Employee Role Xref
Employee ID	RoleID
1	1
1	2
2	1

Query:

1 2 3 4 5 6

SELECT e.EmployeeID, (SELECT STUFF((SELECT ',' + Cast([name] AS VARCHAR(MAX)) FROM Roles r JOIN [EmployeeRoleXref] erx ON erx.EmployeeID = e.EmployeeID AND r.RoelID = erx.RoelID FOR XML PATH('')), 1, 1, '')) FROM [Employee] e

Output:

Name	Roles
Terry	Developer, Manager
Jerry	Manager