I have the following query to concat values using commas:
[Xml].query('for $x in //Name return concat($x, ", ")').value('.', 'nvarchar(max)')
Is it possible to write this using value() only (without query())?
Asked
Active
Viewed 94 times
0
Andrey Shchekin
- 21,101
- 19
- 94
- 162
-
Is your XML the source for the concatenation or is it an intermediate going from rows to XML to concatenated value? – Mikael Eriksson May 02 '12 at 09:24
-
Intermediate, but I do not really want to add ',' to XML. – Andrey Shchekin May 02 '12 at 10:15
-
possible duplicate of [SQL Server performance in xquery with for loop](http://stackoverflow.com/questions/20161949/sql-server-performance-in-xquery-with-for-loop) – Paul Sweatte Jun 25 '14 at 06:06