How to check if a temporary table exists and delete it if it does before creating a temporary table?
You can check if the previously created temporary table exists before creating the same table again in your stored procedure. Drop them if they exist.