Simulating the Sql-99 OLAP window for running sums in S2005
am 19.07.2007 00:15:11 von Rog11228This 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