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.