result of SP to be insert into table
heres my code
create procedure dbo.mypj
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