SELECT UserId, RoleName = stuff( ( SELECT ‘,’ + RoleName FROM #temp AS t WHERE t.UserId = #temp.UserId FOR xml path(’’) ), 1, 1, ‘’ ) into #temp1 FROM #temp GROUP BY UserId