Posted by SQL on 06/13/32 11:28

Create a temp table in the first proc (2) and populate that table in
the second proc (1)
Like this

create stored procedure proc1 (@x int) as
insert into #temp values(@ * @x, @x * @x * @x)
select * from @tbl
GO
--
create stored procedure proc2 (@x int) as
declare @tbl (y1 int, y2 int)
create #temp (y1 int, y2 int)
while @x > 0 begin
(exec proc1 @x) <-- this is my problem
set @x = @x - 1
end
insert into @tbl
select * from #temp

select * from temp
---or select * from @tbl -- you can eliminate @tbl in this proc
GO


I don't know why you are calling the second proc you can do all this
stuff in 1 proc like this
-------------------------------------------------------------------------------
create stored procedure proc2 (@x int) as
declare @tbl (y1 int, y2 int)
while @x > 0 begin
insert into @tbl
values(@ * @x, @x * @x * @x)
set @x = @x - 1
end
select * from @tbl
GO



http://sqlservercode.blogspot.com/

• Next in forum: Re: resultset of proc in another proc
• Prev in forum: resultset of proc in another proc
• Thread view: Re: resultset of proc in another proc

[Reply to this message]