Posted by helmut woess on 10/01/53 11:28

Am 4 Oct 2005 07:23:52 -0700 schrieb SQL:

> 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

That doesn't help immediately. Because both procs can be called
independently by the client program. But i can put the working part in a
third proc which is called by proc1 or proc2, then i can use your
suggestion.
And i can't put everything in one proc, because in my real application the
first proc should calculate different values for one specific contract, the
second proc should calculate the values for a group of contracts (using
proc1) and present the result in a little different output.

But i am still very interested if it is possible without output parameters
and populated tables.

thanks,
Helmut

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

[Reply to this message]