Posted by Doug on 01/30/06 18:21

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!.

• Next in forum: Re: ORDER BY in VIEW not working
• Prev in forum: Re: How to find first not null value in column
• Thread view: Re: ORDER BY in VIEW not working

[Reply to this message]