>Are you having to update these tables or just viewing them?
>If just view then change your query to output to a cursor instead of a table. >Then when you rerun the query it will automaticly over write the old cursor. >Nothing to delete.

I've never used cursors. How do you read the info stored in them?

Steph.