>As has been mentioned, using a query or view in this situation will help the >performance.

OK. you have cast another vote for cursors or views - I shall try this.

>Additionally, you should use the TMPFILES configuration statement to direct the
> temporary files to a local drive and directory. (ie: TMPFILES=C:\TEMPFILES)

Yep. I'm doing that. Thanks George.