title: Can't get this simple temporary table code to work
body: <p>When the middle two lines are taken out, the blank output appears properly (single column)!</p>
  
  <pre><code>CREATE TABLE #ProductNames (ProductName varchar(40));
  
  INSERT INTO #ProductNames
  SELECT p.ProductName FROM DBO.PRODUCTS AS p;
  
  SELECT * FROM #ProductNames;
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/A6R5o.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/A6R5o.png" alt="Screenshot of error while running the whole thing"></a></p>
  
  <p>Here is how the DBO.PRODUCTS look like:</p>
  
  <p><a href="https://i.stack.imgur.com/uHpeH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uHpeH.png" alt="Screenshot of how the main data table looks like"></a></p>
  
  <p>Also, the question carries a strange NOTE/suggestion in the last line that reads: &lt;&lt; Note: you need to specify the Products table as Products, not dbo.Products. >></p>
  
  <p>This is the outcome following that note! -<br>
  [<img src="https://i.stack.imgur.com/deM5C.png" alt="Following the &#39;Note&#39; in the Instructions"><a href="https://i.stack.imgur.com/deM5C.png" rel="nofollow noreferrer">3</a></p>