Community

How to Compute Simple Moving Averages with Time Series Data in SQL Server

(Rick Dobson) Demonstrate techniques for use of SQL Server Windows functions to compute simple moving averages. More specifically, highlight the use of the Windows aggregate avg function for computing simple moving averages for one entity at a time or concurrently for multiple entities.