May 27, 2014 at 9:29 am
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
May 27, 2014 at 9:45 am
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
August 12, 2014 at 11:50 am
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?
----------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply