-1

My table looks something like this (with 7500 rows):

UserName     Company
Eduard       Google
Alex         Google
Mark         Google
Silvia       Microsoft

Any I need it to look like this:

UserName             Company
Eduard, Alex, Mark   Google
Silvia               Microsoft

Any Idea how to achieve this? I am using SQL Server 2017.

Salman A
  • 262,204
  • 82
  • 430
  • 521

1 Answers1

1

In SQL Server 2017 you can use STRING_AGG:

SELECT STRING_AGG(UserName,', ') AS UserNames, Company
FROM @t
GROUP BY Company
Salman A
  • 262,204
  • 82
  • 430
  • 521