SQLTeam.com | Weblogs | Forums

Sql Roll up queries into 1 row

I have a table that pulls document types between two customers. I need to roll this up into 1 row so I can get a consolidated list

You can use concat for that

CONCAT (Transact-SQL) - SQL Server | Microsoft Docs

SELECT CONCAT(CustomerA , ' ', CustomerB, ' ', DocumentTypes)