Select Code to Download

select * into <i>#temporarytablename</i> 
from <i>permanenttablename</i>

select * from <i>#temporarytablename</i>