|
Subject:
|
result of SP to be insert into table
|
|
Posted By:
|
drachx
|
Post Date:
|
10/2/2005 7:23:14 PM
|
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
|
|
Reply By:
|
jbenson001
|
Reply Date:
|
10/3/2005 12:38:08 AM
|
Insert into a global temp table (##temp) or just insert into a physical table then delete it when you are done.
|
|
