You mean if you have a table Employee, you want to copy those records from Employee to temptable #Employee?
Then try this.
if you are going to insert only once, then you can insert without declaring temptable.
select * into #Employee from Employee
else
You can declare temptable and insert.
create table #Employee
([EMPID] int,
[EMPNAME] varchar(100)
)
insert into #Employee
select * from Employee