Convert XML to relational output

• a2zwd

  SSCrazy

  Points: 2356

  More actions

  July 19, 2011 at 1:31 pm

  #241673

  Hi,

  I have a table in DB(sql server 2008) with column XMLDoc of type XML. This will XML source for a invoice.

  Now, I need to retrieve this XML and convert into relational output to store into another database to many invoice related tables.

  I can't use XMLSource coz XML from DB is not sure that always will have the all tables information.

  Even the table exists, some columns may not be available all the time.

  XML source will produce the outputs based on the nodes. Is it possible to get all the columns in the XML to the XMLSource output instead of individual nodes and its columns?

  Or is there any other solution to achieve this?

  Please reply. I am struck at this point.

  thanks

• GSquared

  SSC Guru

  Points: 260824

  More actions

  July 19, 2011 at 1:39 pm

  #1355122

  Can you get what you want via a T-SQL query using XQuery?

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon