Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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 Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 5:24 AM
Points: 94, Visits: 439
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


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 3:30 PM
Points: 352, Visits: 1,868
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
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse