Advertisement
Guest User

Untitled

a guest
Oct 28th, 2016
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. <unsigned value specification> ::=
  2. { <unsigned integer literal> }
  3.  
  4. Declare @MA int = 50
  5.  
  6. Declare @SQL varchar(max) ='Select Date, price, avg(price) over( order by Date, Date rows between '+cast(@MA as varchar(25))+' preceding and current row) as moving_avg from t1 '
  7. Exec(@SQL)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement