The Analytic functions don't, but the OVER clause enhancements allows running totals with the SUM() function and the enhanced OVER clause. See my previous article: The OVER Clause enhancements in SQL Server code named “Denali”, CTP3.[/url] You might also want to see my blog post on this: http://blog.waynesheffield.com/wayne/archive/2011/08/running-totals-in-denali-ctp3/[/url]. In short, the QU still wins, but the newly enhanced OVER clause beats everything else.

Did you click the "TSQL Challenges Winner" icon in my signature? It beat everything else quite handily doing a running total challenge.