Posted by steve on 07/18/07 22:15

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-rapid-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_Calculations.doc

Other new entries on
www.beyondsql.blogspot.com

Dataphor @
www.alphora.com

• Next in forum: Re: How write this sentence with T-SQL
• Prev in forum: Re: Establishing Precedence In ORDERBY Condition Causing Problems.
• Thread view: Simulating the Sql-99 OLAP window for running sums in S2005

[Reply to this message]