Stored Procedures in subqueries.

Results 1 to 2 of 2

Thread: Stored Procedures in subqueries.

  1. #1
    Join Date
    Dec 1969

    Default Stored Procedures in subqueries.

    Can anyone tell me how to use the results of a stored procedure in query? Like my stored procedure returns a table, and i need to perform another query on that table. How can i do that? I was thinking something like this: <BR><BR>select * from (STORED_PROC_NAME) where ID=3<BR><BR>Am i completely off? <BR>thanks guys.

  2. #2
    Join Date
    Dec 1969

    Default Why not just pass the parameter 3 to the sp???

    It would be about 100 times faster. If you do not pass a value then you would run it as you do now.<BR><BR><BR>HTH<BR><BR>Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts