Well, I need to get a median value for a set of numbers, from a query. To my surprise, Sql Server does not have a median function/sproc (well, if you install the analysis tools you do, but I can't ...

Topic says it all. 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 ...