Here is the workable code...
create table t1(code nvarchar(10), name nvarchar(64));
go
insert into t1 values('001', 'Jon Doe');
insert into t1 values('002', 'Michael Doe');
go
create procedure getdata
as
begin
select * from t1;
end
actual code to execute sp and store in temp table
CREATE TABLE #temp
(
code nvarchar(10),
name nvarchar(64)
)
INSERT INTO #temp
Exec getdata