Declaring Multiple XmlNameSpaces.

• Deeps123

  SSC Rookie

  Points: 30

  More actions

  May 5, 2011 at 7:41 pm

  #143811

  Hi there,

  I was wondering whether it is possible to extract Multiple Xml files with different XmlNamespace using single SQL query. i.e declaring multiple XmlNameSpaces in for diferent Xml files with same structure but different Xmlnamespace.

  Not in this way ;With XmlNameSpaces(DEFAULT 'http:...........','htttp.......') AS Test.

  Thanks.

• Mike01

  SSChampion

  Points: 11420

  More actions

  May 6, 2011 at 6:22 am

  #1320951

  Do you have an example of the XML data you are working with and then your expected results?

  For better, quicker answers, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/