| Robbe Morris [C# MVP] 2005-05-03, 8:24 pm |
| This sample shows how:
http://www.eggheadcafe.com/articles/20030804.asp
--
2004 and 2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net/home/listings.aspx
"ashishbandi" <ashishbandi.1ohidn@mail.codecomments.com> wrote in message
news:ashishbandi.1ohidn@mail.codecomments.com...
>
> 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/attachm...?postid=1579804 |
> +----------------------------------------------------------------+
>
>
> --
> ashishbandi
> ------------------------------------------------------------------------
> Posted via http://www.codecomments.com
> ------------------------------------------------------------------------
>
|