Home Dashboard Directory Help
Search

SQL Azure Percentile Functions Availability by David Elish


Status: 

Closed
 as Won't Fix Help for as Won't Fix


1
0
Sign in
to vote
Type: Suggestion
ID: 777060
Opened: 1/21/2013 7:48:23 AM
Access Restriction: Public
0
Workaround(s)
view

Description

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.
Details
Sign in to post a comment.
Posted by Microsoft on 4/25/2013 at 11:46 AM
Closed as explained earlier.

--
Umachandar
Posted by Microsoft 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 Microsoft 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
Sign in to post a workaround.