>
>I just did a test of using TOP 1000. On the table of about 190,000 records it took 1 minute (I was looking at a watch). Keep in mind that the data resides on my own PC so in real case of a customer where their data is on a data server, it will take longer. I guess my SQL is slower because I have NOFILTER clause in it, right?.
My point is, that the same query will not be faster if you remove TOP 1000 clause.
--sb--