title: MS SQL Server: Generate sequential data in SQL
body: <p>In this example, I would like to insert data into a specified table from a view.
  however, one of the field should be a calculated field that today's date; However each row should be incremented by 1 until all data from the other view have been inserted.</p>
  
  <pre><code>Insert INTO myTable SELECT a, b, c, GETDATE() AS d FROM MyView
  </code></pre>
  
  <p>The problem is: d must be today's date only in the first row.  The following row, it must be GETDATE()+1 etc until all values in MyView has been inserted into MyTable.</p>