Thank You Lutz & Paul! Peformance is now improved to great extent after I incorprated your suggestions.

Here's Sample code

--Using (< node > /text())[1]

WITH XMLNAMESPACES (DEFAULT 'urn:schemas-microsoft-com:xml-analysis:rowset')

INSERT #Unit_Test ([End User Name],...

Hi Lutz,

I tried to execute the similar code with additional columns (25 total columns) and found that the performance is very poor. It took me more than 5hrs to fetch...

Thanks Lutz! It worked! 🙂 You Rock!

Thanks & Regards,

Venkatesh Vailaya