want to insert data into temp table

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