Posted by Hugo Kornelis on 02/01/06 00:11

On Tue, 31 Jan 2006 01:26:51 GMT, Beowulf wrote:

>Doug wrote:
>> huh. I never knew that ordering a view was unsupported. It always has
>> worked, I bet it always will, but it is good to know.
>>
>> OTOH, if you take the EXACT same code, stuff it into a stored
>> procedure, it is guaranteed to work.
>>
>> yet another reason not ot use views.
>>
>> thanks!.
>
>I was under the impression that one cannot select from a stored
>procedure or do joins with it (the way one can treat MS Access querydefs
>as virtual tables).
>
>Unfortunately, I have a large number of views that need to be joined
>with physical tables and other views. As far as I know (entirely
>possible I'm wrong), my options are views or user-defined functions that
>return tables.

Hi Beowulf,

That's correct.

Comparing stored procedurs to views is like comparing a hammer to a saw:
they are designed for entirely different purposes, and a good carpenter
knows how to use them both.

--
Hugo Kornelis, SQL Server MVP

[Back to original message]