title: delete & add a record to sql table while incrementing the date
body: <p>I have a SQL table with 364 rows/records each with a unique date. I want to be able to cut &amp; copy the first record when that day has passed and then paste a new record with an incremented date to the bottom of the table... always maintaining a 364 record count.</p>
  
  <p>The record being cut &amp; copied contains several other columns of data and can be copied as is... nothing needs to be changed in those records.</p>
  
  <p>Example:</p>
  
  <pre><code>Date
  ------------------------------------
  2018-05-20... Other columns of data
  2018-05-21... Other columns of data
  2018-05-22... Other columns of data
  2018-05-23... Other columns of data
  2018-05-24... Other columns of data
  2018-05-25... Other columns of data
  2018-05-26... Other columns of data
  ......
  2019-05-17... Other columns of data
  2019-05-18... Other columns of data
  </code></pre>
  
  <p>In the above I would want the 2018-05-20 record to be cut &amp; copied and then pasted as a new record incrementing the last record date by 1. So the pasted record would be 2019-05-19.</p>
  
  <p>I realize my 364 records are one day shy of a year. I have a reason for doing so.</p>
  
  <p>How would I write this stored procedure?</p>