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.


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


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