select * into #temporarytablename from permanenttablename