Error while using FOR XML PATH statement

[Mark_Wonsil]

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.

BAQ Concatenate Inventory Bin information error

You’re missing the whole subquery to concatenate the rows. if your SQL version is 2019+ then try this as a calculated field string_agg(PartBin.BinNum, ' ,'); and group by the other fields in the query. [image] [image] [image]