SELECT Users.id,Users.Name,Users.LastName (SELECT ( STUFF ( ( SELECT ', ' + Roles.description FROM Roles WHERE Roles.UserID=Users.id FOR XML PATH('') ), 1, 2, '' ) ) AS StringValue ) AS UsersRoles FROM Users
SELECT ‘,’ + ColumnName … FOR XML PATH(”
) genera un set di valore separati da virgola.
STUFF(...,1,1,'')
Rimuove la prima virgola e spazio.