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 big problem.

Instead, one can use variable of TABLE Type.

thnx.