Calculate median value?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dmorand
    New Member
    • Sep 2007
    • 219

    Calculate median value?

    Does anyone have any experience with retrieving a median value using SQL server? I'm trying to retrieve a median value from a list of various numerical values.

    Any help would be appreciated.
  • myct
    New Member
    • Dec 2008
    • 4

    #2
    here is a solution for SQL2K and 2K5

    Click here for a solution with code listing for both 2000 and 2005.

    Hope that helps !

    -Shiva
    mycodetrip.com

    Comment

    • dmorand
      New Member
      • Sep 2007
      • 219

      #3
      Thanks, I'll take a look!!

      Comment

      Working...