Jul 4, 2015 · There is very new functionality in Azure SQL Database and SQL Server (starting with 2017) to handle this exact scenario. I believe this would serve as a native official method for …

Jul 19, 2017 · SQL STUFF function roll up multiple rows Asked 8 years, 3 months ago Modified 2 years, 1 month ago Viewed 21k times

Nov 1, 2019 · STUFF function to display multiple columns with comma-separated in SQL Server Asked 5 years, 11 months ago Modified 5 years, 11 months ago Viewed 8k times

Jan 24, 2015 · 3 The issue here isn't the stuff() function. It's the subquery and the XML processing. There really isn't an alternative in SQL Server. I mean, there are two other …

Aug 1, 2015 · SQL Query taking long time with STUFF function Asked 10 years, 2 months ago Modified 10 years, 2 months ago Viewed 10k times

Jun 5, 2015 · How can i use stuff function for multiple columns in SQL server? Asked 10 years, 4 months ago Modified 4 years, 1 month ago Viewed 35k times

Jan 24, 2017 · Group By and STUFF combined result in sql server Asked 8 years, 9 months ago Modified 8 years, 9 months ago Viewed 20k times

Mar 8, 2016 · I've looked online a few days now to how to use STUFF on sql server, most of the examples I see are involving only two tables and my query is going through 3 tables and I just …

Oct 27, 2015 · How to concatenate text from multiple rows into a single text string in SQL Server Asked 17 years, 1 month ago Modified 9 months ago Viewed 3.4m times

Jun 17, 2019 · 9 Apply sorting to any result in SQL is done by using the order by clause. It's not the stuff function that's giving you a hard time, it's the fact that you didn't specify an order by to …