Friday, March 23, 2012

OPEN XML

I have to insert one table by using the concept OPENXML

But i want to insert a table lot of fields i require, in the open XML few fields fields are there , so i want to selet some fields from other table

can u guide me for this scenario to INSERT some fields from one table and some in OPENXML as a single insert statement

Awaiting for Reply PLease

Thanx

Consider using the openXml to create a temporary table first. Then join the two tables as the base for the insert.

No comments:

Post a Comment