Icon of program: SQL 2008 Median and Perce…

SQL 2008 Median and Percentile Aggregate Functions for Windows

Download now

Used SQL 2008 Median and Percentile Aggregate Functions for Windows?

Editors’ Review

Download.com staff
This utility adds median and percentile aggregate functions to SQL Server 2008. It significantly enhances T-SQL scripting capabilities for complex data analysis.
Enlarged image for SQL 2008 Median and Perce…
SQL 2008 Median and Percentile Aggregate Functions 0/1

  • Pros

    • Calculates median and percentile directly in SQL Server.
    • Improves query speed, reliability, and efficiency.
    • Simplifies and cleans up T-SQL scripts.
    • Straightforward configuration via a script file.
    • Functions are used like built-in aggregates.

  • Cons

    • Only compatible with SQL Server 2008.
    • Does not provide other missing statistical functions.
Icon of program: SQL 2008 Median and Perce…

SQL 2008 Median and Percentile Aggregate Functions for Windows

Download now

Used SQL 2008 Median and Percentile Aggregate Functions for Windows?

Explore More

Full Specifications

GENERAL
Release
Latest update
Version
1.0
OPERATING SYSTEMS
Platform
Windows
Operating System
  • Windows 10
  • Windows XP
  • Windows Vista
  • Windows 2000
  • Windows 2003
  • Windows NT
  • Windows 7
  • Windows Server
Additional Requirements
None
POPULARITY
Total Downloads
280
Downloads Last Week
11
Report Software

Program available in other languages

Last Updated

Developer’s Description

By Quip IT Solutions
Provide median and percentile aggregate functions for SQL Server 2008.
SQL Aggregate functions perform a calculation on a set of values and return a single value. Microsoft SQL Server supports only basic aggregate functions, such as SUM or MAX, whilst many of the statistical and analytical functions are missing. QUIP IT Solutions provides user made aggregate functions which enhance T-SQL scripting environment so you can calculate median and percentile within the databa like any other built-in aggregate function. It makes your SQL/TSQL queries and stored procedures much faster, more reliable and more efficient than any other technique. It also makes your script much simpler and cleaner. Configuring these functions is very straightforward. You are given a script file which you run like any other SQL script against the database you want to create these aggregate functions in. And that is it! you are now ready to use our aggregate functions the same way as you use any other SQL aggregate function with or without a "group by" statement. SQL Server 2008 does support multiple parameters in user made aggregate functions, so the syntax is relatively simple here. It works exaclty the same as MS Excel the only difference is that instead of selecing a range you use a field name in the function. For instance, Select b,dbo.Percentile(a,.90) [90th Percentile] from tmp group by b --90th Percentile Select b,dbo.Percentile(a,.95) [95th Percentile] from tmp group by b --95th Percentile Select b,dbo.Median(a) [Median] from tmp group by b -- Median
Download.com
Your review for SQL 2008 Median and Percentile Aggregate Functions