sql - Concatenate text from multiple rows into a single text string ...
SQL Server 2017+ and SQL Azure: STRING_AGG Starting with the next version of SQL Server, we can finally concatenate across rows without having to resort to any variable or XML …
aggregate functions - Can we use SQL Server STRING_AGG () in …
Mar 29, 2023 · Can we use SQL Server STRING_AGG () in queries using GROUP BY ROLLUP () Asked 2 years, 10 months ago Modified 1 year, 2 months ago Viewed 23k times
sql - How to sort the aggregate values from STRING_AGG () IN …
This question is not about SQLServer's version of STRING_AGG() with ORDER BY. SQL Server pages: How to get strings comma separated in ascending order with SQL Server's …
Get unique values using STRING_AGG in SQL Server
May 29, 2018 · Get unique values using STRING_AGG in SQL Server Asked 7 years, 8 months ago Modified 11 months ago Viewed 214k times
Alternative to STRING_AGG in with SQL - Stack Overflow
Jan 9, 2020 · Alternative to STRING_AGG in with SQL Asked 6 years, 1 month ago Modified 6 years, 1 month ago Viewed 45k times
String_agg for SQL Server before 2017 - Stack Overflow
Mar 19, 2018 · Can anyone help me make this query work for SQL Server 2014? This is working on PostgreSQL and probably on SQL Server 2017. On Oracle it is listagg instead of …
sql - Optimal way to concatenate/aggregate strings - Stack Overflow
They have implimented STRING_AGG () in Azure SQL Database as well. That should provide the exact functionality originally requested in this post with native and built in support. @hrobky …
How to write the T-SQL STRING_AGG function - Stack Overflow
Jul 14, 2018 · The issue is, because SQL Server 2014 doesn't have access to STRING_AGG, the stored procedures we wrote for our Azure SQL database won't work locally. The function …
sql - STRING_AGG aggregation result exceeded the limit of 8000 …
Sep 19, 2022 · select c.id , c.bereichsname , STRING_AGG(j.oberbereich,',') oberBereiches from stellenangebote_archiv as j join bereiche as c on j.bereich_id = c.id group by c.id, …
Grouped string aggregation / LISTAGG for SQL Server
May 8, 2017 · The article needs an update - the CLR was for SQL Server 2005. 2008 supports multiple parameters in an aggregate function, so you can recreate MySQL's …