I created a BAQ that should concatenate the CommentText field of multiple records into a single column using the FOR XML PATH statement. I am receiving a “Severity: Error, Text: SQL Statement” error when I test the BAQ. I have tried to simplify the query from what I originally had, trying to ident…

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. [image] BAQ Concatenate Inventory Bin information error ERP 10 You’re missing the whole subquery to concatenate the rows. if your SQ…

I can’t wait to use that function.

First, get rid of the replace stuff and just look at the field without the string manipulation stuff. Then work the replace stuff into it piece by piece. never mind, if you’re on a modern version, use String_Agg()

I think your new name should be Brandon Aggregate. Or at least make your EpiUsers name @baggregate. It’s kinda a windowing function to your soul. :person_shrugging:

Thank you @Mark_Wonsil & @Banderson ! I had not done this since upgrading.

Error while using FOR XML PATH statement

Kinetic ERP

Mark_Wonsil (Mark Wonsil) April 25, 2023, 3:44pm 2

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.

Topic		Replies	Views
BAQ Concatenated Rows to Single Field Kinetic ERP baq	11	1531	July 13, 2022
FOR XML in BAQ Epicor ERP 10 e10 , baq	33	5025	October 14, 2022
FOR XML PATH versus STRING_AGG Epicor ERP 10 baq	66	14355	October 28, 2024
BAQ incorrect syntax near 'FOR' Epicor ERP 10 e10	10	2785	December 20, 2022
FOR XML PATH error on Upgrade Epicor ERP 10 epicor , baq	4	1977	January 27, 2021

Error while using FOR XML PATH statement

Related topics