Posted by Simon Hayes on 10/01/16 11:19

"pb648174" <google@webpaul.net> wrote in message
news:1119452414.930552.191880@g49g2000cwa.googlegroups.com...
> 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.
>

See here:

http://www.sommarskog.se/share_data.html

Simon

• Next in forum: Re: Sql Server Password Expiration?
• Prev in forum: Re: Problems with Windows Authentication
• Thread view: Re: using a stored procedure as a sub query

[Reply to this message]