select OrderNumber, STRING_AGG(Flag, ',')
from orders
group by OrderNumber;
ASKER
;with txn as
(
select 'Order1' OrderNumber, 'WC' Flag union all
select 'Order1' OrderNumber, 'STOP' Flag union all
select 'Order1' OrderNumber, 'OK' Flag union all
select 'Order2' OrderNumber, 'WC' Flag union all
select 'Order2' OrderNumber, 'OK' Flag
)
SELECT OrderNumber, STUFF((
SELECT ',' + Flag
FROM txn
Where OrderNumber = a.OrderNumber
FOR XML PATH('')
), 1, 1, '') Flags
FROM txn a
Group by OrderNumber
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
TRUSTED BY
It doesn't say what database product you are using.
Based on your previous questions, I'm guessing SQL Server.
Now, what version are you using?
If 2017 or later, it's a simple string_agg:
https://docs.microsoft.com/en-us/sql/t-sql/functions/string-agg-transact-sql?view=sql-server-ver15