title: "Incorrect syntax" error using OVER()
body: <p>I have a sales budget for every trading day of the month.  So for day 1 the budget is 300, for day 2 the budget is 400, and then month to date budget is 700.  I get this error in my query:  <code>Incorrect syntax near 'ROWS'.</code></p>
  
  <pre><code>select 
  TradingDate
  ,Budget
  ,sum(Budget) over (PARTITION BY TradingDate
  order by TradingDate asc
  ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING),1) AS BudgetMTD
  from #4
  </code></pre>