SQL Azure Percentile Functions Availability by David Elish

Closed

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

Type:	Suggestion
ID:	777060
Opened:	1/21/2013 7:48:23 AM
Access Restriction:	Public

Workaround(s)

view

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 (expand)

English

SQL Azure Database

Add these functions.

PERCENTILE_CONT
PERCENTILE_DISC

Faster Development

0 attachments

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

Microsoft