Posted by helmut woess on 09/30/45 11:28

Am Wed, 05 Oct 2005 01:54:33 +0200 schrieb Simon Hayes:

> 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

very good information!

thank you very much,
Helmut

• Next in forum: Re: Error handling when calling external sql-Files
• Prev in forum: Re: image data type
• Thread view: Re: resultset of proc in another proc

[Reply to this message]