> I thought the same thing. While I'm not a MS SQL guru, I put 'TOP 100
> PERCENT' after SELECT in the query. The Enterprise Manager does not
> indicate how many rows come back. I save it as a VIEW in MS SQL and do a
> 'select count(*)...' and, yes, it comes back 42164877 records.
No, it comes back 1 record with the count in it, the ORDER BY is useless
for a count(*), etc.
What is it that you are trying to do exactly ?