merging several rows into one single row

[Baron]

Is there any reverse procedure for the sa_split_list procedure? I have a select statement which delivers one column with several rows, and I want to have all those rows in one row.

[VolkerBarth · Accepted solution]

Yes, the list aggregate function...

Such as

select list(table_name, ',' order by table_id)
from sys.systab

[Baron · Accepted solution]

OK, thank you very much

[VolkerBarth · Accepted solution]

FWIW, the combination of list() and sa_split_list() is a powerful tool to split and re-combine contents (or vice-versa)...