drew.allen (5/17/2016)

---

Try changing your CROSS APPLY to an OUTER APPLY. The CROSS APPLY filters out nodes that don't have any instances of the element specified, whereas the OUTER APPLY...

drew.allen (5/17/2016)

---

Two things:

1) You said that you were missing data? What results are you getting?

2) You xml data doesn't support the desired results. Your desired results...

Sorry about that, i updated the previous post with the desired output for that specific XML in the post.

Thanks!

drew.allen (5/16/2016)

---

leon_clf (5/16/2016)

---

Hi Drew,

I came across a little problem i noticed that data is being lost with each CROSS APPLY i add, i did something like:

:

:

:

from V_DATA

CROSS APPLY V_DATA.PARAMETER.nodes('/HAM.5')...

drew.allen (5/16/2016)

---

leon_clf (5/16/2016)

---

drew.allen (5/16/2016)

---

You haven't given your desired output, but it looks like you can get what you want by simply using the nodes() function on the subtrees received from...

drew.allen (5/16/2016)

---

You haven't given your desired output, but it looks like you can get what you want by simply using the nodes() function on the subtrees received from the first...