Sql Roll up queries into 1 row

Transact-SQL
1

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

image
image694×487 13.1 KB

2

You can use concat for that

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

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