aggregate functions - Can we use SQL Server STRING_AGG () in queries ...
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 - 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 witchery. …
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
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 STRING_AGG () and …
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 string_agg. Here is …
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
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 needs to …
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 mentioned this …
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 GROUP_CONCAT's parameters.
How to use STRING_AGG function inside another STRING_AGG …
Sep 25, 2024 · How to use STRING_AGG function inside another STRING_AGG function in SQL Server Asked 1 year, 4 months ago Modified 1 year, 4 months ago Viewed 754 times