title: Is there a way to perform a DATEADD() with a range of increments in T-SQL?
body: <p>Looking for a shortcut to getting a column with a range of dates +/- 3 days of a specific date.  I haven't found an elegant shortcut.  My premise maybe off, I haven't found a way to have a range of values in the increment parameter of DATEADD() but this is the gist of what I am looking to do.</p>
  
  <pre><code>SELECT    
      DATEADD(dd, BETWEEN -3 AND 3, x.myDate)       [Dates]
  FROM
      myTable x
  </code></pre>
  
  <p>I know that this doesn't work but wanted to know if there was an equivalent shortcut to get the desired dates.</p>