Using a stored procedure like a subquery

Using a stored procedure like a subquery

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 asselect e_id from emails where e_id like ("%1%")create procedure pevalasselect e_id from emailswhere e_id in(execute pcore)

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.

Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular