Implement Window Functions in SQL Azure - by JohnArcherRisk

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.

Sign in
to vote
ID 787199 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 5/18/2013 9:03:53 AM
Access Restriction Public


The introduction of Window Functions in SQL Server 2012 is a powerful and tremendously useful feature missing from SQL Azure.  I recently developed an on-premise solution in SQL Server 2012 making heavy use of these new functions and was unable to migrate this solution to SQL Azure.  Any idea as to when SQL Azure will support window functions?
Sign in to post a comment.
Posted by cte00 on 9/8/2014 at 10:03 PM
These functions have a great deal of literature, and they greatly improve productivity. Rather than making us look for alternative solutions, please reconsider to implement this in SQL Azure. It might not be in-time for my current need, but maybe some people's need in the near future.
Posted by Greg Low - Australia on 8/12/2013 at 9:59 PM
Please reconsider the decision about not implementing these.

One of the touted benefits of changes to SQL in Azure was the move to a single code base. If it's the same code base, why is there complexity in enabling window functions? They will allow for much more elegant and efficient code. Efficient code is what we all want in a shared environment like Azure.
Posted by SAinCA on 6/18/2013 at 10:50 AM
Doesn't this beg the obvious question, "If Azure is a flagship Product for MS and these are 'known' deficiencies that many, many apps use, WHY are there 'no plans to enable those in SQL Azure'?"

On-premise or private cloud (hosted, not using Azure) are our choices for "real" apps, then... "Real" = "full blown, as functional as an in-premise app".

Do not understand this decision! Especially do not understand it in wake of the pronouncement that "you will see new features first in Azure". Big Deal! If we don't have the old features, knock yourselves out developing new ones for Azure - at least they might be prime-time-ready when they get into the "real" Product! (SQL Azure = QA Test-bed AFAIC)
Posted by Microsoft on 6/18/2013 at 8:47 AM
Hello John,
Thanks for your feedback. We are aware of the missing SQL Server 2012 features and at this point we have no plans to enable those in SQL Azure.

Umachandar, SQL Programmability Team