title: Adding a value to a 'date' column caused an overflow
body: <pre><code>with MyDates as 
  (
  
      SELECT
          cast( '01-oct-2020' as date ) AS MyDate,
          DATENAME( DW, cast('01-oct-2020' as date ) ) AS NameOfDay
  
      UNION ALL
  
      SELECT
          DATEADD( DAY, 1, MyDate ) AS MyDate,
          DATENAME( DW, DATEADD( DAY, 1, MyDate ) ) AS NameOfDay
      FROM
          MyDates
      WHERE
          DATEADD( DAY, 1, MyDate ) &lt; DATEADD( DAY, -1, DATEADD( MONTH, 3, MyDate ) )
  )
  select
      *
  from
      MyDates
  order by
      MyDate desc
  option (maxrecursion 0)
  </code></pre>
  <p>I am trying above code. It runs fine if I run it without <code>order by</code> clause.</p>
  <p>SQL throws an error on using <code>order by</code> clause.</p>
  <blockquote>
  <p>Adding a value to a 'date' column caused an overflow</p>
  </blockquote>
  <p>Please help</p>