title: How can I create an auto incrementing Id in a temp table?
body: <p>I created a temp table in my stored procedure:</p>
  
  <pre><code>CREATE TABLE #tbl (
          [Id]         INT,
          [Correct]    BIT     
          )
  </code></pre>
  
  <p>How can I populate this table with an autogenerated increasing number for the Id and this data:</p>
  
  <pre><code>SELECT Correct FROM question
  INNER JOIN answer
  ON    (question.questionId = answer.questionId)
  WHERE question.questionid = 25
  ORDER BY answer.answerId
  </code></pre>