<div>
I'm using SQL 2005 but it says Rank / Row_Number is not a recognized function name. How could that be? Thanks!
</div>


I'm using SQL 2005 but it says Rank / Row_Number is not a recognized function name. How could that be? Thanks!

<div>
I tested on a db running on SQL 2005 and it worked. Thanks!
</div>


I tested on a db running on SQL 2005 and it worked. Thanks!

<div>
<div class="content wysiwyg-content">
I know how to calculate Median from Ken's book 'The Guru's Guide to Transact-SQL', but the example given in the book only deals with one set (group) of numbers. In my case, I need to group by each code and before group by I have a total of 18 million records so using cross join (one way talked about in the book to get Median) might take a long time. If using Identity, i wonder how to insert id which starts 1 again when a new group starts. Thanks! 
</div>
</div>


I know how to calculate Median from Ken's book 'The Guru's Guide to Transact-SQL', but the example given in the book only deals with one set (group) of numbers. In my case, I need to group by each code and before group by I have a total of 18 million records so using cross join (one way talked about in the book to get Median) might take a long time. If using Identity, i wonder how to insert id which starts 1 again when a new group starts. Thanks! 

How to calculate Median for each group from a large set of data?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.