Found the problem. I overlooked the obvious. No disk space!!! After I freed up about 8 GIGs the query works fine. Thanks for the input.

Thanks. I will check into this and see if I have any luck.