Focuses on SQL Server, especially T-SQL development and programming, with the aim of presenting projects and problems in SQL Server and the thought process behind delivering a solution.
Wednesday, January 8, 2020
SQL FOR XML for string concatenation
Just a quick link to a great tip of using the FOR XML clause to concatenate values in rows into a single string (grouped by another column).
These posts go into the mechanics of the FOR XML, and some debate as to the pros and cons.
No comments:
Post a Comment