Todd Buttrey
todd_5036 at msn.com
Wed Apr 16 10:07:28 CDT 2003
What does the return from spMySP look like? ----Original Message Follows---- From: Michael Brosdorf <michael.broesdorf at web.de> Reply-To: dba-sqlserver at databaseadvisors.com To: <dba-sqlserver at databaseadvisors.com> Subject: [dba-SQLServer]SP question Date: Wed, 16 Apr 2003 16:47:42 +0200 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 _________________________________________________________________ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus