I want to "concatenate" all the "Text"-rows into one single row and get one row as a result. Is this even possible? I use MSSQL Server 2005.
SQL Server – Group and Concatenate Many Rows to One
sqlsql-serversql-server-group-concat
sqlsql-serversql-server-group-concat
I want to "concatenate" all the "Text"-rows into one single row and get one row as a result. Is this even possible? I use MSSQL Server 2005.
Best Answer
Use FOR XML PATH:
Another option - use string concatenation:
Please note that the latter one isn't guaranteed to work, afaik, officially the behaviour of "@s = @s + ..." for multi-row resultset is undefined.
MAXDOP 1
hint is used here to prevent the optimizer from creating a parralel execution plan, as this will yield an incorrect result for sure.