Anyone know how to use OPENXML?
I've searched on "OPENXML" and come up with nothing on this forum, so I may be the expert around here. God help us.
I know how to use the SQL sp_preparedocument and sp_removedocument (or whatever they're called). I've gotten as far as getting OPENXML to retrieve two attributes from each node in my document and return a rowset from a doc that looks like:
root
-record
---attribute1
---attribute2
-record
---attribute1
---attribute2
etc.
I'm looking for examples of how to read more complicated documents that might have nested nodes. For example:
root
-record
---attribute1
---attribute2
-----node1
-------attribute3
-------attribute4
---------node2
------------attribute5
-record
... (more of the same)
JoshT where are you? You seem like the XMLpert around here.