Re: Can you select from a Derived table calling a stored proc?
From: Anith Sen (anith_at_bizdatasolutions.com)
Date: 11/29/04
- Next message: Anith Sen: "Re: Updating several fields in a table with a select statement"
- Previous message: Chip: "Updating several fields in a table with a select statement"
- In reply to: we7313: "Can you select from a Derived table calling a stored proc?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 29 Nov 2004 15:44:19 -0600
No, you cannot. As a work around you can use a passthough query like
OPENQUERY with your server name as a loop back to do this. Check out SQL
Server Books Online for details & examples.
As an alternative, you could execute the stored procedure & get the results
in a #temp table & then select from the #temp table as well. Also another
option ( only applicable in some cases ) would be to re-write the stored
procedure as a table valued UDF. For details, refer to SQL Server Books
Online as well.
-- Anith
- Next message: Anith Sen: "Re: Updating several fields in a table with a select statement"
- Previous message: Chip: "Updating several fields in a table with a select statement"
- In reply to: we7313: "Can you select from a Derived table calling a stored proc?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
