According to MSDN, Transact-SQL does not support Median as an aggregate function. However, I'd like to know if it's feasible to develop this capability (using the Create Aggregate function, user defined function, or some other method).
What would be the best approach to accomplish this—to permit the computation of a median value in an aggregate query, assuming a numeric data type—if it were possible?