title: There is already an object named '#tmptable' in the database
body: <p>I´m trying to execute stored procedure but I get an issue of an existing temporal table, but I just create one time and use into another part of code</p>
  
  <pre><code>SELECT ...
  INTO #tmpUnidadesPresupuestadas 
  FROM proce.table1 
  
  --Insertar in table src..
  INSERT INTO table (
   ....) 
  SELECT
  ....
  FROM
      #tmpUnidadesPresupuestadas
  </code></pre>
  
  <p>I get this message: </p>
  
  <blockquote>
    <p>There is already an object named
    '#tmpUnidadesPresupuestadas' in the database.</p>
  </blockquote>
  
  <p>How can I solve it? Regards</p>