ChrisM@Work (11/21/2014)

---

sgmunson (11/21/2014)

---

Can I ask what might seem like a dumb question? Why is anyone trying so hard to write this query in such a way as to make it rather difficult to understand it's objective?

You mean this (already suggested by the OP)?

ChrisM@Work (11/21/2014)

---

...This however does work, and should return the expected results (it would have been nice to have some data to test with):

...

FROM

Table1 AS a

CROSS APPLY a.data.nodes('.../Node1') AS T1(F) -- part 1

OUTER APPLY a.data.nodes('.../Node2') AS T2(F) -- part 2

...

Edit: fixed tags