Need to Read XML - Mutli-step using nested Shared values

[kbednarchuk]

I'm trying to read a multi-step XML from where one rowset contains data I need to carry forward into the next rowset. I set the nestedSharedValues to true, but then how do I access this in my insert SQL?

Code: Select all

---

<rowset name="shift" nestedSharedValues="true">

Thanks in advance