sql server - SQL finding average between dates -


i have user write in 2 dates, say: '2013-7-8','2013-7-15'
stored procedure executes , returns , updated table.
2 columns include:

avg_paid_volume ---- cns_amt

numb_im_looking_for -------------------------10000
numb_im_looking_for ------------------------ 20000
numb_im_looking_for -------------------------30000
... etc

cns_amt volume on specified time period.
i'm looking average paid volume across between specified 2 dates, called @dt_from , @dt_to -> in case 10000/8, 20000/8 , 30000/8

have values inputed table (into 'numb_im_looking_for')

declare @dt_to datetime declare @dt_from datetime set @dt_to = convert(datetime,'2013-7-8') set @dt_from = convert(datetime,'2013-7-15')  update tablename set avg_paid_volume = (cns_amt / datediff(d,@dt_to,@dt_from)) 

datediff key here


Comments

Popular posts from this blog

php - Calling a template part from a post -

Firefox SVG shape not printing when it has stroke -

How to mention the localhost in android -