Simulating the Sql-99 OLAP window for running sums in S2005

Simulating the Sql-99 OLAP window for running sums in S2005

am 19.07.2007 00:15:11 von Rog11228

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/07/dataphor-example-of-ra pid-application.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/sqlwindowexample.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_Clause_and_Ordered_Calculatio ns.doc

Other new entries on
www.beyondsql.blogspot.com

Dataphor @
www.alphora.com