Bruce,

>Well, it was very fast until the COPY TO. Then it got almost completely stuck on COPY TO :(

Do you need to get it into a table ? Can work from the filtered table directly (maybe reporting, displaying in grid etc) ? IOW what do you want to do with your table ?

Seems you've got performance trouble writing data to the disk, maybe you should aviod writing data. Is you HD defragmented ? Maybe you can try to write it to another (network) drive.

Walter,