Post reply

For XML Auto Query

  • October 7, 2009 at 1:08 pm

    #385527

    hi

    I want to use to different tables and generate xml output using the Select clauses

    Select fld1,fld2

    from Table1

    For xml path ('Tbl1')

    Select fld4,fld5 ,fld6

    from table2

    for xml path('TBl2')

    After this i want to combine the xml output and also generate schema for the whole output

    using xml auto

    something like this

    for xml auto ,root('root'), ELEMENTS, XMLSCHEMA('row')

    thanks in advance

  • October 7, 2009 at 2:52 pm

    #1063092

    Please read the link in my signature and post sample data as described.

    Make sure to include your expected output together with what you've tried so far.

    This will help us help you.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

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