In response to the original problem reported....

From my experience, you can't use variable or temporary tables in a dynamic sql. That could probably be the reason you get the errror that...