XML Path For was a hack used until SQL Server provided the String_agg command. Lots of posts here by @Banderson explaining the better way.
Mark_Wonsil
(Mark Wonsil)
2
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| BAQ Concatenated Rows to Single Field | 11 | 1576 | July 13, 2022 | |
| FOR XML in BAQ | 33 | 5083 | October 14, 2022 | |
| FOR XML PATH versus STRING_AGG | 66 | 14481 | October 28, 2024 | |
| BAQ incorrect syntax near 'FOR' | 10 | 2821 | December 20, 2022 | |
| FOR XML PATH error on Upgrade | 4 | 1985 | January 27, 2021 |