Thanks all for all the good replies. I have decided to go with temporary tables. The "The Curse and Blessings of Dynamic SQL" is a good one to have a...

Thanks jermy

I messed up with my wordings what I want to do is to pass a temporary table variable to a dynamic sql execution.