Re: averaging with multiple ranges

[ian Butterworth]

Just thought I'd add the basic 'one-off average' query to aid any help.

SELECT FORMAT(10*LOG10(AVG(POW(10,(meas/10)))),1) As 'AVmeas' FROM timehistory
WHERE date_stamp BETWEEN @start AND @end;