Re: [SQLDownUnder] TOP 100 PERCENT

[Damian Maclennan]

Gah!

Are you looking over my shoulder ? I just found one of them as well!

Damian



On Tue, 15 Mar 2005 13:00:25 +1000, Wheat, Mitch <mwheat@xxxxxxxxxxxx> wrote:
> Hi Greg
>  
> Only seen it in views to get around the ordering limitation.
>  
> Regards,
> Mitch
> 
> -----Original Message-----
> From: Greg Low [mailto:greg.low@xxxxxxxxxxx]
> Sent: Tuesday, 15 March 2005 10:58 AM
> To: SQLDownUnder@xxxxxxxxxxxxxxxxxxxxxx
> Subject: [SQLDownUnder] TOP 100 PERCENT
> 
> Hi Folks,
>  
> I'm doing a code review at a site today. The code is littered with:
>  
> SELECT TOP 100 PERCENT ....
>  
> or 
>  
> SELECT DISTINCT TOP 100 PERCENT ...
>  
> I've never seen anyone write that before. The optimiser seems to treat it as
> though there wasn't even a TOP statement at all (as you'd hope) but I'm
> dumbfounded as to what the coder could have had in mind.
>  
> Has anyone else seen that?
>  
> Thanks,
>  
> Gregto unsubscribe to this list, please send a message back to the list with
> 'unsubscribe' as the subject. Powered by mailenable.com - List managed by
> http://www.readify.net 
> 
> EOM ________________________________
> EMAIL DISCLAIMER NOTICE 
> 
> 
> 
> This message is the property of HATCH.  The information in this email is
> confidential and may be legally privileged. It is intended solely for the
> addressee.  Access to this email by anyone else is unauthorised.  If you are
> not the intended recipient, any disclosure, copying,distribution or any
> action taken or omitted to be taken in reliance on it, is prohibited and may
> be unlawful. 
> 
> If you have received this message in error please notify HATCH immediately
> via e-mail to : mailadmin@xxxxxxxxxxxx 
> 
> For more details about HATCH visit http://www.hatch.com.au
> ________________________________
> 
> 
> to unsubscribe to this list, please send a message back to the list with
> 'unsubscribe' as the subject. Powered by mailenable.com - List managed by
> http://www.readify.net 
> 
> 
> 
> 
> 
>


to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net