Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

XML to SQL conversion Expand / Collapse
Author
Message
Posted Tuesday, May 27, 2014 9:28 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 14, 2015 6:29 AM
Points: 100, Visits: 464
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
Post #1574839
Posted Tuesday, May 27, 2014 9:45 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, January 29, 2016 12:03 PM
Points: 450, Visits: 2,413
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# - http://www.SQLsharp.com/
Post #1574849
Posted Tuesday, August 12, 2014 11:50 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 4:01 PM
Points: 728, Visits: 1,475
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?
Post #1602395
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse