Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 using SP in query

Author  Topic 

khalik
Constraint Violating Yak Guru

443 Posts

Posted - 2001-10-23 : 01:52:14
hi
i have a small query which takes results results of the stored procedure.. is it possible. it goes like this

select * from customer where cust_id in(sp_cust_check)

sp_cust_check is stored procedure...
whick perform some check and update and returns a recordset of vaild customers...
i cannot create addition table to store....
nor can i include my query in stored procedure.... i will be useing the same procedure for few more thing... so nay suggestion..........

   

- Advertisement -