XML Query

• Jules Bonnot

  SSCertifiable

  Points: 5488

  More actions

  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]

• Sureshkumar Ramakrishnan

  Ten Centuries

  Points: 1200

  More actions

  November 15, 2006 at 11:36 am

  #672076

  Use the xp_xml_preparedocument.

  read more about it in books online

   

   

  ---

  Kindest Regards,

  Sureshkumar Ramakrishnan
  

• Rick Todd

  Hall of Fame

  Points: 3302

  More actions

  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