Calling a stored procedure with parameters from another stored procedure 
Author Message
 Calling a stored procedure with parameters from another stored procedure
How can I call a stored procedure that has parameters from another stored
procedure?

What we want to do is use the result set from a stored procedure with
further criteria.  Doing something like this (excuse me if this is way off,
I'm new at this): SELECT * from spTest '11' WHERE job = '993039' does not
work.  Can something like this be done (I realize it might have to be done a
completely different way).

TIA!
Jody



Sat, 23 Mar 2002 03:00:00 GMT
 Calling a stored procedure with parameters from another stored procedure

try this





this example uses the output of one stored procedure as the parameter
of a second stored procedure

if oyu are talking about wanting to nest a stored procedure within a
select statement such as

select x1, exec sp_test1 from temp

I don't think this is possible under sql server which is a shame since
you have been able to do this in Oracle for at least 3 yrs.

Hope this helps
Craig

On Tue, 5 Oct 1999 10:15:29 -0400, "Jody"

Quote:

>How can I call a stored procedure that has parameters from another stored
>procedure?

>What we want to do is use the result set from a stored procedure with
>further criteria.  Doing something like this (excuse me if this is way off,
>I'm new at this): SELECT * from spTest '11' WHERE job = '993039' does not
>work.  Can something like this be done (I realize it might have to be done a
>completely different way).

>TIA!
>Jody



Sun, 07 Apr 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Calling a stored procedure with parameters from another stored procedure

2. Error at obtaining output parameters of the stored procedure, calling other stored procedure

3. Calling Stored Procedure that calls Stored Procedure in ASP

4. Calling a Java Stored Procedure from another Java Stored Stored Procedure

5. temporary tables in stored procedures/parameter views vs stored procedures

6. ado recordsets from stored procedures, stored procedures have input parameters

7. output parameters stored procedures / extended stored procedures

8. ado recordsets from stored procedures, stored procedures have input parameters

9. Stored Procedure calling Stored Procedure

10. Call a stored procedure from another stored procedure

11. Calling a Stored Procedure from a Stored Procedure

12. How to call an Oracle Stored procedure from MSSQL Server Stored Procedure


 
Powered by phpBB® Forum Software