title: Temp table already exists
body: <p>Hi I have a temporary table in which I am trying to insert records based on a where condition but it throws an error that it already exists. 
  I have tried to change the names but that is not the issue as the temporary tables are delete when the session ends.</p>
  
  <p>I think I am writing the query right.</p>
  
  <pre><code>   SELECT [Name]
          INTO #TEMP_REJECT
          FROM #TEMP_VALIDATION
          WHERE Name = @Name
  </code></pre>
  
  <p>I am trying to insert #TEMP_REJECT FROM #TEMP_VALIDATION </p>
  
  <p><strong>Error message</strong></p>
  
  <blockquote>
    <p>"There is already an object named '#TEMP_REJECT' in the database."</p>
  </blockquote>
  
  <p>Please suggest.</p>
  
  <p>Thank you for your help.
  R</p>