Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Nov 20, 1998

Using a stored procedure like a subquery

Question:
I'm trying to get something like this to work. How can I take the output of a stored procedure and use it in a subquery?


create procedure pcore as
select e_id from emails where e_id like ("%1%")

create procedure peval
as
select e_id from emails
where e_id in
(
execute pcore
)

Answer:
The way to accomplish your task is to create a temp table with the same structure as the result set from your stored procedure. Then execute an insert into #temptable:

( 
   exec pcore
)

You can then use your temp table in your subquery.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date