Posted by Simon Hayes on 10/01/73 11:28

helmut woess wrote:
> Hello,
>
> i want to use the result set from a stored proc in another stored proc, for
> example:
>
> create stored procedure proc1 (@x int) as
> declare @tbl (y1 int, y2 int)
> insert into @tbl values(@ * @x, @x * @x * @x)
> select * from @tbl
> GO
> --
> create stored procedure proc2 (@x int) as
> declare @tbl (y1 int, y2 int)
> while @x > 0 begin
> insert into @tbl select (exec proc1 @x) <-- this is my problem
> set @x = @x - 1
> end
> select * from @tbl
> GO
> --
>
> I know i could use output parameters. But i want to know if something is
> possible with SQL-Server?
>
> thanks,
> Helmut

This is a good summary of the options:

http://www.sommarskog.se/share_data.html

Simon

• Next in forum: Re: HELP WITH RANKING !!!!( please)
• Prev in forum: Re: Transaction Management
• Thread view: Re: resultset of proc in another proc

[Reply to this message]