I think he's trying to refer to something like a search engine - so the data is returned in pages of 20 or so instead of 1000 records being sent...

I have to agree with Paul Thornett - you are not providing a meaningful order by clause. Yes it is interesting that SQL v7 and 2k return the results...