Concatenate values from one field in multiple rows into one one field on all rows

I have been utilizing the recursive query code provided by Dieter in the link above (works great), but I have a slight variation on the original question. How would Dieter's code change if we wanted to concatenate all child_ids todether into one field for a given parent_id, however, we want to keep separate records for each Location?