SQL Server December 15th, 2006 Take the high road to middle ground See how to use Common Table Expressions to derive a more efficient median.