[SQLDownUnder] TOP 100 PERCENT

[Greg Low]

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,

 

Greg

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