quote:
If you use the 'permanent' temporary table with the SPID column, you will want to clear it at the start of your procedure, not at the end. If you do not clear it at the start, and something happens to abort the process, the next user can get data that does not belong to them. Also, if you cluster on SPID, you will have fewer contention problems if the table is relatively full, rather then mostly empty.
Tom - Thanks for commenting on my suggestion. I didn't appreciate the impact of doing the delete at the end until I saw your post. I'll start doing it your way.
Best regards,
SteveR