SELECT UserId,
STUFF((SELECT ',' + Cast(A.RoleName as varchar)
FROM View_User_Role A Where A.UserId=B.UserId FOR XML PATH('')),1,1,'') As RoleName
From View_User_Role B
From View_User_Role B
Group By UserId