I am trying to combine two rows into one and have tried to follow examples online with coalesce and stuff xml paths, but keep getting errors. In our db a person can have multiple races attached to their record. I would like each person to show up as one row with all of their races in a list.
The Output I am trying to get would be one row like this where the multiple races are combined in one row:
You are nearly there. Use your query to capture all the data, then use the stuff/xml over that:
answered Aug 11 at 07:45 AM
Kev Riley ♦♦