Michael Brösdorf
michael.broesdorf at web.de
Wed Apr 16 10:21:12 CDT 2003
If the sproc is called using the query analyzer, it returns a single column containing a number of rows. Michael -----Ursprüngliche Nachricht----- Von: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]Im Auftrag von Todd Buttrey Gesendet: Mittwoch, 16. April 2003 17:07 An: dba-sqlserver at databaseadvisors.com Betreff: Re: [dba-SQLServer]SP question 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com