T-SQL Concatenate & group multiple rows into a single row

Viewed 30658

I'm looking for a way to group whilst also concatenating rows into a comma separated string. Example:

Name            Place
Steve Jones     New York
Steve Jones     Washington
Albert Smith    Miami
Albert Smith    Denver

to ...

Steve Jones    New York, Washington
Albert Smith   Miami, Denver

Greatly appreciated

4 Answers
Related