Let me thank you guys for your responses and better clarify by issue:

-- Thanks Steve

I have a Proc that returns one of two (will be more in the future) possible...

I am trying to do a very similar thing with several SELECT INTO 's using the same temp table name, because of the possibility of differing source data structures.

I then...