Bob,

A "global" temp table (prefixed with ##) will be visible to all connections. Any temp table that is prefixed with a single pound sign (#) is scoped to the connection.

>I know they are removed when the sp ends, but I want to recreate them for each interation of the loop for the person currently being processed.

You will get better performance if you TRUNCATE the table instead of dropping and recreating it.

-Mike