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 writing SQL predicates to make the most out of the indexes, it is very important to make certain that the predicates are written in a manner that does not cause the database manager to avoid using ...