title: Adding column with NULL values to temp table
body: <p>I am trying to create a temp table with values from an existing table. I would like  the temp table to have an additional column (phone), which does not exist from the permanent table. All values in this column should be NULL. Not sure how to do, but here is my existing query:</p>
  
  <pre><code>SELECT DISTINCT UserName, FirstName, LastName INTO ##TempTable 
  FROM (
        SELECT DISTINCT Username, FirstName, LastName 
            FROM PermanentTable
  )  data 
  </code></pre>