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.

Like most databases created in the last few decades, SQL Server allows developers ... a researcher for Microsoft, this scalar function can cause a query that normally takes 1.6 seconds to instead ...