Dashboard for Open Jobs

[NateS (Nate Schoonover)]

It is easier than you think.
I think this link has a lot of good info about how to implement the subquery.

BAQ: Calculated Field Concatenate Rows to single field

Is there a function/query that will allow multiple returned rows to be combined into a single field? I’m looking thru the PO Tables and finding all PO numbers for a specific job. The job may have 3 POs. PO Number : Job Number 70001 : 00245 70010 : 00245 70008 : 00245 I want to combine/concatenate these to be something like Job Number : PO Numbers 00245 : 70001,70010,70008

I still use the FOR XML PATH version, as String_Agg still doesn’t work in our version of epicor.