Posted by Erland Sommarskog on 01/30/08 22:23

Gert-Jan Strik (sorry@toomuchspamalready.nl) writes:
> According to SQL Server 2005's Books Online, aggregate window functions
> only support partitioning by a column. IOW, AFAIK SQL Server does not
> (yet?) support PRECEDING or CURRENT ROW as windowing selectors.

Yep. There is a request on ORDER BY for aggregates on Connect:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=254387

There is also one for RANGE and ROWS
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=254392

There are also a whole more requests for enhancements to the OVER clause,
most of them taken from the ANSI standard. You view a list on:
https://connect.microsoft.com/SQLServer/feedback/SearchResults.aspx?SearchQuery=%22OVER+clause+enhancement+request%22

Would this come in SQL 2008 (it does not seem so), SQL 2008 would be
really hot.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]