RE: [SQLDownUnder] TOP 100 PERCENT

[Wheat, Mitch]

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