OPENXML: Complex schema query

#1

Here is the file:

ashishbandi wrote:

Quote:

*Hi all:

I am trying to load SQL "text" column that contains the raw xml
response, received as part of a batch operation. I figured the part
to dynamically load the text to SQL. I need help with OPENXML query
for the complex xml schema. Please help!!

As you can see from the attached sample xml doc, the ShipNotice node
can be repeated as many no. of times. I am particularly stuck on how
to obtain the tracking info and "corressponding" item. The logic is
the tracking number(s) info has to be mapped to the corresponding
item (based on the occurrence and the "Item's" linenumber attribute
value.

Please help me figure out a way to get that data. I have gotton to
the part where I am able to get the tracking info, but stuck on
matching it with item.

Please ignore some of the columns if not present in teh xml. I am
attaching a partial xml file here. *

+----------------------------------------------------------------+

Quote:

Attachment filename: samplexmlschema.txt |
Download attachment: http://www.codecomments.com/attachme...postid=1579805 |
+----------------------------------------------------------------+

--
ashishbandi
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------

#2

The file is still missing...

Best regards
Michael

"ashishbandi" <ashishbandi.1ohido (AT) mail (DOT) codecomments.com> wrote

Quote:

Here is the file:

ashishbandi wrote:
*Hi all:

I am trying to load SQL "text" column that contains the raw xml
response, received as part of a batch operation. I figured the part
to dynamically load the text to SQL. I need help with OPENXML query
for the complex xml schema. Please help!!

As you can see from the attached sample xml doc, the ShipNotice node
can be repeated as many no. of times. I am particularly stuck on how
to obtain the tracking info and "corressponding" item. The logic is
the tracking number(s) info has to be mapped to the corresponding
item (based on the occurrence and the "Item's" linenumber attribute
value.

Please help me figure out a way to get that data. I have gotton to
the part where I am able to get the tracking info, but stuck on
matching it with item.

Please ignore some of the columns if not present in teh xml. I am
attaching a partial xml file here. *

+----------------------------------------------------------------+
| Attachment filename: samplexmlschema.txt |
|Download attachment:
http://www.codecomments.com/attachme...postid=1579805 |
+----------------------------------------------------------------+

--
ashishbandi
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

OPENXML: Complex schema query

microsoft.public.sqlserver.xml microsoft.public.sqlserver.xml

OPENXML: Complex schema query - 05-03-2005 , 06:08 PM

Re: OPENXML: Complex schema query - 05-04-2005 , 11:03 AM