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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy