Susan Zeller
szeller at cce.umn.edu
Wed Apr 16 10:07:46 CDT 2003
I'm pretty sure you can't do this with a sproc. A user defined function would work great, however. --Susan -----Original Message----- From: Michael Brosdorf [mailto:michael.broesdorf at web.de] Sent: Wednesday, April 16, 2003 9:48 AM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer]SP question Dear group, is it possible to use the result set of a stored procedure in the where clause of another SQL-Statement? Something like: Select * from MyTable where My_ID in (spMySP) (This does not work...) The SP returns a couple of ID's (only one column) TIA, Michael _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com