Oracle’s PERCENTILE_CONT implementation using SQL Server 2005 analytic functions…

I saw an interesting question today in the MSDN Transact-SQL forum about implementing PERCENTILE_CONT analytic function that is available in Oracle in SQL Server. The function description as noted in the Oracle docs is below:   The PERCENTILE_CONT function is an inverse distribution function that assumes a continuous distribution model. It takes a percentile value…

7