Creating Comma Separated Lists In SQL
Hi All,
I am attempting to merge something like this in my SQL Server database:
[TicketID], [Person] T0001 Alice T0001 Bob T0002 Catherine T0002 Doug T0003 Elaine
Into this:
[TicketID], [People] T0001 Alice, Bob T0002 Catherine, Doug T0003 Elaine
I need to do this in both SQL Server and Oracle.
I have found the function GROUP_CONCAT
for MySQL that does exactly what I need here, but MySQL is not an option here.
EDIT: Test bench:
DECLARE @Tickets TABLE (
[TicketID] char(5) NOT NULL,
[Person] nvarchar(15) NOT NULL
)
INSERT INTO @Tickets
SELECT 'T0001', 'Alice' UNION ALL
SELECT 'T0001', 'Bob' UNION ALL
SELECT 'T0002', 'Catherine' UNION ALL
SELECT 'T0002', 'Doug' UNION ALL
SELECT 'T0003', 'Elaine'
SELECT * FROM @Tickets