Sorry about the sturcture of XML. The <ARTICLES> tag allow you to encompass multiple <ARTICLE> tags. That's why it has been added.

Also the mistake in the XPATH would be rectified...

nice suggestion for using temp tables...

Its better to use them if the XML files are large...

If any exceptions occurs, temporary tables are not destroyed from the memory.

This can be a...

Tricky one...

i m working on it ... wait for some time

Are you in need of a generic stored proc. (to insert data in...