SQL Azure Percentile Functions Availability - by David Elish

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 777060 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 1/21/2013 7:48:23 AM
Access Restriction Public


Any idea when PERCENTILE_CONT and PERCENTILE_DISC will be available in SQL Azure? They are available in SQL Server 2012. I was very disappointed when I realized they weren't supported after migrating a project from 2012 to Azure that is heavily dependent on these functions.
Sign in to post a comment.
Posted by Umachandar [MSFT] on 4/25/2013 at 11:46 AM
Closed as explained earlier.

Posted by Umachandar [MSFT] on 4/25/2013 at 10:04 AM
Hello David,
I am closing this item since we don't have any plans at the moment to enhance or change the T-SQL surface area for SQL Azure. We will evaluate these requests again in the future.

Umachandar, SQL Programmability Team
Posted by Umachandar [MSFT] on 1/28/2013 at 3:05 PM
Hello David,
Thanks for your suggestion. We are aware of the feature disparity between SQL Azure & SQL Server 2012/2008/2005. We hope to address those in the future, right now we don't have any firm plans.
Another reason some of these features are not enabled in SQL Azure is due to the behavior changes - for example, PERCENTILE_CONT syntax reserves a new multi-token keyword (WITHIN GROUP). Since SQL Azure doesn't support database compatibility level yet, we do not have a way to expose features that are available only in the 110 compat level for example.

Umachandar, SQL Programmability Team