string-agg

In SQL Server pre-2017, you can do: select stuff( (select ‘,’ + cast(t.id as varchar(max)) from tabel t for xml path (”) ), 1, 1, ” ); The only purpose of stuff() is to remove the initial comma. The work is being done by for xml path.