RE: [SQLDownUnder] TOP 100 PERCENT

[David Richards]

Perhaps I should leave this for someone who actually knows but...

 

I do remember there was a reason to do this.  I just can't remember what it was.  It was in a fairly specific situation though.

 

Regards
David Richards

Software Support Technician
Product Development
Australian Arrow P/L
Phone:	03 8770 2255
Fax:	03 8770 2325

"If we can hit that bullseye, the rest of the dominoes
will fall like a house of cards... checkmate!"

-Zapp Brannigan, Futurama

-----Original Message-----
From: Greg Low [mailto:greg.low@xxxxxxxxxxx]
Sent: Tuesday, 15 March 2005 13:58
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

 

The contents of this email, and any attachments, are strictly private and confidential. It may contain legally privileged or sensitive information and is intended solely for the individual or entity to which it is addressed. Only the intended recipient may review, reproduce, retransmit, disclose, disseminate or otherwise use or take action in reliance upon the information contained in this email and any attachments, with the permission of Australian Arrow Pty. Ltd. If you have received this communication in error, please reply to the sender immediately and promptly delete the email and attachments, together with any copies, from all computers. It is your responsibility to scan this communication and any attached files for computer viruses and other defects and we recommend that it be subjected to your virus checking procedures prior to use. Australian Arrow Pty. Ltd. does not accept liability for any loss or damage of any nature, howsoever caused, which may result directly or indirectly from this communication or any attached files.

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