OVER clause enhancement request - Progressive ordered calculations - by Itzik Ben-Gan

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


158
1
Sign in
to vote
ID 254397 Comments
Status Closed Workarounds
Type Suggestion Repros 11
Opened 1/28/2007 12:00:28 PM
Access Restriction Public

Description

SQL Server 2005 introduced only partial support for the OVER clause. It is our strong believe that a more complete implementation of the OVER clause should be prioritized highly in consideration for future enhancements in SQL Server. A more complete implementation of the OVER clause can help in solving many common business problems with simpler, more intuitive, and faster solutions than available today and also substantially reduce the need for cursors. 
The following paper details the feature enhancement requests:
http://www.insidetsql.com/OVER_Clause_and_Ordered_Calculations.doc
The current feedback item addresses the OVER clause enhancement request - Progressive ordered calculations, discussed in the paper in section 4 item viii.
Sign in to post a comment.
Posted by Microsoft on 3/7/2011 at 6:54 PM
Hi Itzik,
Thanks for your feedback. I am closing this request as "Won't Fix". I don't see us adding PREVIOUS function to SQL Server in the future. Once we have the window functions support as described in the ANSI SQL standard, most of these calculations will be possible directly or using those features.

--
Umachandar, SQL Programmability Team
Posted by Microsoft on 12/13/2007 at 3:34 PM
Dear Itzik.

Thanks a lot for your feedback... and the strong voting support for this feature. Indeed, as you know, I am very much in favor of extending our functionality in this area. For a variety of reasons we did not get this into SQL Server 2008, but we are certainly looking into it for a future release.

Keep the votes and comments coming...
Michael