Posted by Patrick Fiche on 07/08/05 12:41

Thanks for the answer.
However, I thought that the optimizer was designed only to optimize the
query but resultset was independant of the order of execution of
filters.
Here, it appears that depending on the order of application of filters,
result is not the same....
I guess that this is a special case due to the abuse of conversion
use...

Thanks
Patrick


*** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: Re: STOP unexpected_kernel_mode_trap after installing SP4
• Prev in forum: Re: T-SQL problem...selecting TOP 1 of each GROUP in GROUP BY?
• Thread view: Re: Is it a SQL Server 2000 bug

[Reply to this message]