Calculating Values within a Rolling Window in Transact SQL

(Dwain Camps) Before the SQL Window functions were implemented, it was tricky to calculate rolling totals or moving averages efficiently in SQL Server. There are now a number of techniques, but which has the best performance?

Read More - Register for Free Membership