INSERT INTO @yourTableVar Execute yourSP

create table TestingVariables (id int, strng varchar(10))
insert into TestingVariables (id, strng) values (1,'a')
insert into TestingVariables (id, strng) values (2,'b')
insert into TestingVariables (id, strng) values (3,'c')
insert into TestingVariables (id, strng) values (4,'d')
GO

declare @Testng2 table (id int, somestring varchar(10))

insert into @Testng2
select * from TestingVariables

select * from @Testng2
GO

drop table TestingVariables

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass