I need to calculate some Means and Medians.
In Excel, there is a "Median" function. Is there a similar one in SQL? I am using SQL Server 2005. "Mean", as far as I know, is just "Average", so I know that is available.
Currently, I am using a Stored Procedure to acquire the Median, but it is much too slow.