select * into #temporarytablename from permanenttablename ##

##

select * from #temporarytablename