Pushing Stored Procedure output into #temp table with out using openrowset

Why don't you go for select * into temptable and then output that result. Below is a sample record.

create table testtable
(
id int identity(1,1),
name varchar(100)
)

insert into testtable select 'a'
insert into testtable select 'b'


select name into #outputtable from testtable

select * from #outputtable

drop table #outputtable

drop table testtable 

---

Please mark as helpful and propose as answer if you find this as correct!!! Thanks, Rakesh.