I have two data result sets. They share serigate key, but I would like to add the one field from the result set of B into A.
Where A's id equals B's id add Count to xml structure.
I know that I can use a "Set Value" activity to add items to xml variables. But how would the XPath expressions work.
I want: Where A.id= B.id insert B.Count into A.Count.
cheers,