Posted by Erland Sommarskog on 10/01/18 11:19

pb648174 (google@webpaul.net) writes:
> Is there any way to do the following?
>
> select Max(FieldOne) From (
> spGetSomeData 100,'test' )
>
> Or do I need to define a view and have the stored proc use that view?
> The stored proc does some things with temp tables that would be
> difficult to replicate with a view which is why I'm asking.

Have a look at http://www.sommarskog.se/share_data.html for some ideas.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]