Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DeepakNewton
Starting Member
39 Posts |
 Posted - 2008-06-27 : 08:34:49
|
| HI ALLI have two tables that i need to insert into first table and using pkCoID, i need to insert the corresponding values into the second tablePlease see the below table structure and XML data, give some idea to develop tblCoSBusiness pkCoIdfkAccountIDtblPoSBusinesspkPoSIdposNamefkCoId<Head><CoSBusiness><CD><Cond>Comments<Cond><Ps><PoS1><posName>John</posName></Parameter></Parameters></CD><CD><Cond>Comments1<Cond><Ps>..... </CD> |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-27 : 11:18:56
|
| Use OPENXML to insert xml into table.I dont know where you'll get data for AccountID field from. Also the XML you posted is not a valid xml(there is a close parameter tag but without a start tag).http://msdn.microsoft.com/en-us/library/ms186918.aspx |
 |
|
|
|
|
|
Insert with XML Data