title: Add dates everyday to a specific date
body: <p>In SQL I want to take this startdate '2021-01-22'
  and every day add data of a currentdate to that start date. So my datatable will always keep the start date, but every day add the newest date.</p>
  <p>Tried something like this in my stored procedure;</p>
  <pre><code>DECLARE @DATESTART DATE;
  DECLARE @DATEEND DATE;
  SET @DATESTART =   '2021-01-22';
  SET @DATEEND =  (SELECT DATEADD(day, DATEDIFF(day, 1, @DATESTART ), 1));
  </code></pre>