Search

OVER clause enhancement request - ORDER BY for aggregates by Itzik Ben-Gan

Closed
as Fixed Help for as Fixed

296
0
Sign in
 to vote
Type: Suggestion
ID: 254387
Opened: 1/28/2007 11:36:50 AM
Access Restriction: Public
Duplicates: 372548
0
Workaround(s)
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 - ORDER BY for aggregates, discussed in the paper in section 4 item i.
Details (expand)
Product Language
English

Category

SQL Engine

Proposed Solution

Implement the OVER clause enhancement request - ORDER BY for aggregates.

Benefits

Faster Development
Improved Performance

Other Benefits

Simpler, more intuitive, and faster code
File Attachments
0 attachments
Sign in to post a comment.
Posted by Microsoft on 7/13/2011 at 4:38 PM
Hello Everyone,
Thanks for your feedback. We have now added support for window functions that is compatible with ANSI SQL:2008 standard.
Below are the links to the documentation for latest CTP of SQL Server Denali:

http://msdn.microsoft.com/en-us/library/ms189461(SQL.110).aspx
http://msdn.microsoft.com/en-us/library/hh213234(v=SQL.110).aspx

--
Umachandar, SQL Programmability Team
Posted by WebSolProv on 10/20/2010 at 6:56 AM
Please MS can we have some feedback on the likelihood (and of course, intended release date) for the subsequent version of SQL Server. While SQL 2008 R2 is certainly something to be proud of, it still doesnt really contain these (or anything close) much needed and requested enhancements.
Posted by Maurice Pelchat on 9/24/2010 at 5:28 AM
We have practical cases in applications we develop that would make this features very cool and the SQL code much simpler.

I gave SQL formation to programmers recently about actual SQL windowing functions and some examples about how much they simplify T-SQL querying. However this particular feature can't be reproduced easily to perform well in all cases.
Posted by Microsoft on 9/11/2007 at 4:49 PM
Note: This feedback is for a series of requests for OVER clause enhancement. These items will be looked at both individually and together in future feature design.

This feature unfortunately did not fit into our schedule for SQL Server 2008. Based on customer input, we had prioritized ORDER BY for aggregates and the ROW/RANGE feature, but in the end decided that in order for this feature to be truly useful, we needed to implement more functionality than time would allow. This is a top priority for the next release, and we continue to look forward to great suggestions from you.
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement