Posted by --CELKO-- on 09/23/07 23:01

>> I might also watch for a future version of SQL Server to include
RUNNING_TOTAL() OVER(ORDER BY <column(s)>), similar to ROW_NUMBER()
which is effectively a special case of a running total: <<

Nope, not likely. The ANSI/ISO syntax is already there and I hope SQL
Server would use it:

SUM(foobar)
OVER ([ORDER BY ..]
[PARTITION BY ..]
<range clause>)

The <range clause> defines how many preceding or following rows are in
the window (that is the name of the OVER() clause. You have a wide
range of options here. Look it up; DB2 and Oracle have full
implementations.

[Back to original message]