2nd way is I declared the @table and inserted the XML node level records into @table variable and then doing update joining the @table with main table which I need...
Thanks for your valuable response.I have mentioned the inserts into customer and then address table. Will it be accurate to add customerid in address table after getting it from scope_identity()...