SQL Server 2005: Using OVER() with Aggregate Functions

(Jeff Smith) One of new features in SQL 2005 that I haven’t seen much talk about is that you can now add aggregate functions to any SELECT (even without a GROUP BY clause) by specifying an OVER() partition for each function. Unfortunately, it isn’t especially powerful, and you can’t do running total

Read More - Register for Free Membership