Post reply

XML Query

  • November 15, 2006 at 10:37 am

    #115356

    I need to insert the results from an open xml query into a table. However i only want to selct the first parent node and its child not all parents nodes. Is there a way i can do this with openxml queries or wil i have to do something else.

    www.sql-library.com[/url]

  • November 15, 2006 at 11:36 am

    #672076

    Use the xp_xml_preparedocument.

    read more about it in books online

     

     

    Kindest Regards,

    Sureshkumar Ramakrishnan

  • November 16, 2006 at 9:49 am

    #672362

    There's pretty good documentation for OPENXML in Books Online. If you have problems, post a reply, and I'll try to help you out. I've done a fair amount with that functionality.

    Cheers,

    Rick


    Rick Todd

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

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