Post reply

XML to Relational Help

  • March 5, 2008 at 3:19 pm

    #76918

    I have some XML data in the following format in rows;

    column id, column xml

    id1

    id2

    So I basically have a list of serialized objects in each row. I want to convert this into the following;

    column id,column x, column y

    id1 1 2

    id1 3 4

    id2 5 6

    id3 7 8

    I'm still learning XQueries and I'm kinda baffled by this.

  • March 5, 2008 at 3:25 pm

    #785807

    Your XML markup got "whacked" (you need to do some find and replace stuff before posting it for it not to disappear).

    Replace < with &lt; ( that's "ampersand el-Tee semicolon", all four characters)

    Replace > with &gt; ( that's "ampersand Gee-Tee semicolon", all four characters)

    That being said - you're looking to use the XML NODES() syntax. Look that up in books online if you get a chance, or - repost the actual XML and I'll see if I can whip up an example.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply