hi guys,
heres my code
create procedure dbo.mypj
@period datetime
@coname nvarchar(50)

declare @temptable table( counterid int identity(1,1)),
logdate datetime,coname nvarchar(50)
select * from @temptable


i need to run this in another procedure and get the result and insert it into another table.

is this possble?
i cannot insert another code inseide this same SP because of another comp.

hope u can help me..tnx

Insert into a global temp table (##temp) or just insert into a physical table then delete it when you are done.