Post reply

nested xml query for auto using xmlSchema

  • October 14, 2009 at 4:19 pm

    #139540

    hi ,

    i want the query of my sql to be a nested one

    something like this

    <row fld1="abc" fld2="xyz">

    <row year=2004 val=20 />

    </row>

    <row fld1="abc11" fld2="xyz1">

    <row year=2005 val=20 />

    </row>

    <row fld1="abc12" fld2="xyz1">

    <row year=2004 val=20 />

    </row>

    also for this query I want the inlineschema

    how can I write this query

    Thanks in advance

  • October 14, 2009 at 4:25 pm

    #1066039

    It would be much easier to help if you'd provide the table schema and sample data in a readily-consumable form.

    Here's an exmple of how to post sample data and schema:

    http://www.sqlservercentral.com/articles/Best+Practices/61537/"> http://www.sqlservercentral.com/articles/Best+Practices/61537/

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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