How to Concatenate Text from Multiple Rows into a Single String in SQL Server

 In SQL Server, you can concatenate text from multiple rows into a single text string using the FOR XML PATH('') clause. Here's an example:

Let's say you have a table called MyTable with a column named TextColumn that you want to concatenate.

SELECT 
    STUFF(
        (SELECT ', ' + TextColumn
        FROM MyTable
        FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'),
    1, 2, '') AS ConcatenatedText
FROM MyTable
GROUP BY SomeGroupingColumn;

In this example, the STUFF function is used to remove the leading comma and space from the concatenated string. The FOR XML PATH('') clause is responsible for concatenating the rows.

Make sure to replace MyTable with the actual name of your table, TextColumn with the actual name of the column you want to concatenate, and SomeGroupingColumn with the column you want to group the concatenation by. If you don't want to group the concatenation, you can remove the GROUP BY clause.

Note that if your text contains special characters that need to be escaped in XML, you can use the REPLACE function to replace those characters with their XML-escaped counterparts before concatenation. For example, REPLACE(TextColumn, '&', '&') will replace ampersands with the XML escape sequence.

I hope this helps! Let me know if you have any further questions.