This is a Dataphor/Sql Server 2005 'demo' based on the concept of the
ansi Sql-99 OLAP window for cumulative sums.
Dataphor - An example of rapid application development
http://beyondsql.blogspot.com/2007/0...plication.html

The setup scripts can be downloaded here. They contains all table,
views,
operators, event-handlers etc. including an sql stored procedure
to run the demo:
http://www.geocities.com/d4tosql/D4/...dowexample.zip

Screenshots of the demo here:
http://www.geocities.com/d4tosql/D4/sqlwindow1.jpg
http://www.geocities.com/d4tosql/D4/sqlwindow2.jpg

Sql-99 standard describing the sql window here:
ISO/ANSI: Introduction to OLAP functions
http://tinyurl.com/2taahc

Lack of support in Sql Server 2005 here:
Itzik Ben-Gan and Sujata Mehta
OVER Clause and Ordered Calculations
http://www.insidetsql.com/OVER_Claus...lculations.doc

Other new entries on
www.beyondsql.blogspot.com

Dataphor @
www.alphora.com