Can we see the code of the stored procedure.

Is the hash table a temporary table (last for one connection) or a more permanent one?