Very Computer

I've done this before, but I cannot remember how.

I want to use the result set from a stored procedure in another stored
procedure....

In other words:

+ '%'
AND ID IN (******Results from P1*************)

HELP!!!!!!

John,

One simple way to do this is to create a temp table in PS run the exec into
that table within P2 and then call that from the stored procedure select eg

go

create table #tempid (ID int)


AND ID IN (select ID from #tempid)
go

This should do what you want

I hope this was of use.

Stephen Robinson (SQL MVP)

Can you live with selecting from a separate View instead of a Stored Procedure?
(Create View...)

Charlie Barrett
Flower Mound

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Does your PC get bored while you're away? A CPU is a terrible thing to waste, so take him to http://setiathome.ssl.berkeley.edu/

his CPU. Your PC will be processing Radio Telescope signals from Arecibo, using state-of-the-art DSP algorithms like FFT's and
Correlators. Then it uploads the results back to SETI (the Search for Extra-Terrestrial Intelligence)... I told you it was
cool!!!

And if your PC makes one of the most important discoveries of all time (a signal from a distant civilization), he will be the
envy of the Net, because the SETI team will give him credit in their worldwide press release (oh yeah, you'll get credit, too,
so you won't get jealous and make a scene).

I've done this before, but I cannot remember how.

I want to use the result set from a stored procedure in another stored
procedure....

In other words:

+ '%'
AND ID IN (******Results from P1*************)

HELP!!!!!!