Calling A Stored Procedure from another Stored Procedure 
Author Message
 Calling A Stored Procedure from another Stored Procedure
I have a stored procedure what returns values in two OUTPUT paramaters.
I want to call this SP from another SP within a SELECT statement so that
it returns a set of results based on the current record in the Select
statement.  Does anyone have a clue how I can do this.  I can't seem to
be able to place an EXEWCUTE command within a SELECT statement.  HELP!

Cheers,
G.C. Seibert



Mon, 28 May 2001 03:00:00 GMT
 Calling A Stored Procedure from another Stored Procedure

You can't place af Exec inside a select statement so you will need to break
the code down. First call the SP and get the parameters and the use them in
your select.


Quote:
>I have a stored procedure what returns values in two OUTPUT paramaters.
>I want to call this SP from another SP within a SELECT statement so that
>it returns a set of results based on the current record in the Select
>statement.  Does anyone have a clue how I can do this.  I can't seem to
>be able to place an EXEWCUTE command within a SELECT statement.  HELP!

>Cheers,
>G.C. Seibert




Mon, 28 May 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Calling a Stored Procedure from a Stored Procedure

2. QUESTION: How can I call a Stored Procedure from another Stored Procedure

3. calling a stored procedure inside a stored procedure

4. Calling Java Stored Procedure from SQL Stored Procedure

5. How do I call a stored procedure from another stored Procedure

6. Calling a stored procedure within a stored procedure.

7. Calling a stored procedure from a stored procedure

8. Calling a stored procedure by another stored procedure

9. Call a stored procedure in another stored procedure

10. Calling a Stored Procedure from a Stored Procedure

11. Can I call a stored procedure from a stored procedure

12. Call a stored procedure from another stored procedure


 
Powered by phpBB® Forum Software