Re: [SQLDownUnder] TOP 100 PERCENT

[Damian Maclennan]

Stop it, you're freaking me out :)


On Tue, 15 Mar 2005 13:05:11 +1000, Wheat, Mitch <mwheat@xxxxxxxxxxxx> wrote:
> 
> 
> Hi Damian 
> 
> Didn't you know about that hacked webcam? Wave!!!..... 
> 
> Mitch 
> 
> -----Original Message----- 
> From: Damian Maclennan [mailto:damian.mac@xxxxxxxxx] 
> Sent: Tuesday, 15 March 2005 11:04 AM 
> To: SQLDownUnder@xxxxxxxxxxxxxxxxxxxxxx 
> Subject: Re: [SQLDownUnder] TOP 100 PERCENT 
> 
> 
> 
> 
> 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
> 
> 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