RE: [SQLDownUnder] TOP 100 PERCENT

[Wheat, Mitch]

Title: RE: [SQLDownUnder] TOP 100 PERCENT

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

---