SP in IN 1

[balor]

Hi,

I want to use the values from a sp in a WHERE-Clause. Do any one have a example of how I can do that in the simplest way.

This is what I want to do:

SELECT
*
FROM
Table1
WHERE
Table1.ID IN (SELECT ID FROM sp_GetID)

 

[guljar]

You cannot use stored procedure in this way. If u had function then u could. SQL server 2000 introduces functions.
But I think, if I know what u actually want to do I can give u a suggestion. I mean actually what should be the return value of SP.

 

[balor]

Yes I know I can't use sp in this way. It was only a example of what I want to do. I can solve it in many different ways but I want to do it as simple as possible because I'm going to add this criteria to many different procedures.

 

[guljar]

But you don't answer my question what would be the return value of your sp. let me know.

 

[tlbroadbent]

You could use a temporary table.

Create Table #temp (ID int)
Insert #temp
Execute sp_GetID

SELECT
*
FROM
Table1
WHERE
Table1.ID IN (SELECT ID FROM #temp)

Drop table #temp Terry

http://members.home.net/tlbroadbent/prog.htm

_____________________________________
Man's mind stretched to a new idea never goes back to its original dimensions. - Oliver Wendell Holmes