title: Adding a value to a 'datetime2' column caused an overflow
body: <p>I know why I'm seeing this error, it's because some of my <code>locationDeletionDate</code> is '9999-12-31 00:00:00.0000000', and adding 90 days to the <code>locationDeletionDate</code> (as I do in my query) causes the error in the title:</p>
  
  <pre><code>...WHERE                
  (bpj.JobStatus = 'Live') 
  AND (l.locationEffectiveDate &lt;= SYSDATETIME()) 
  AND (dateadd(d,90,l.locationDeletionDate) &gt;= SYSDATETIME())...
  </code></pre>
  
  <p>I guess what I need is a conditional <code>CASE</code> in my <code>WHERE</code>-clause to ensure the date will not error if 90 days are added? Or is there a more elegant way?</p>