Anyone know the best way to write a median aggregate function in ms sql server 2k? I've seen a couple ways of doing it when I briefly searched google but they weren't presented as functions.

Learn what aggregate functions are, how to use them in SQL queries, and why they are useful for BI. Find examples of common scenarios and calculations.

Oracle, SQL Server, Postgres, DB2 - the list goes on.<BR><BR>The reality is you have to restructure your query. A CTE isn't necessary, but will likely make the query more readable.