XML to SQL conversion

• clucasi

  SSCrazy

  Points: 2113

  More actions

  May 27, 2014 at 9:29 am

  #286958

  I have the following XML file and want inserting into a SQL table, the problem I am having is that the XML has two row nodes.

  These need to be inserted into one row, when I code the insert the xml is spread over two rows.

  Could any body help.

  Cheers

• Solomon Rutzky

  SSCoach

  Points: 16430

  More actions

  May 27, 2014 at 9:45 am

  #1716742

  clucasi (5/27/2014)

  ---

  I have the following XML file and want inserting into a SQL table, the problem I am having is that the XML has two row nodes.

  These need to be inserted into one row, when I code the insert the xml is spread over two rows.

  Could any body help.

  Cheers

  Hi there. I don't see any example code or attachment. Also, if this is just an XML question and has nothing to do with CLR / .Net integration, then maybe the question should be posted to a general SQL programming forum?

  SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
  Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
  Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
  Info sites — Collations     •     Module Signing     •     SQLCLR

• MMartin1

  One Orange Chip

  Points: 27841

  More actions

  August 12, 2014 at 11:50 am

  #1737304

  It helps to be able to see what you are seeing. If this is still an issue for you can you post a sample of your xml data? Have you looked into the XML source in SSIS?

  ----------------------------------------------------