Thanks Wayne and everyone else for your insights.

I just wanted to be sure that i am not the only one who has faced this issue. 🙂

I'll do my analysis on whats the best mix of temp tables and table variables in future.