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.

In the screenshot below, the same data has been summed three ways using the SUM, SUBTOTAL and AGGREGATE functions in cells A7, B7 and C7, respectively. (The formulas in row 7 are spelled out on row 8 ...