http://sqlblog.com/blogs/michael_coles/archive/tags/mvp/functions/row_5F00_number/windowing+functions/dense_5F00_rank/sql+2005/default.aspxTags: mvp, functions, row_number, windowing functions, dense_rank, sql 2005enCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/michael_coles/archive/2009/11/19/please-vote-windowing-enhancements-in-sql-server.aspxFri, 20 Nov 2009 03:45:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:19010Mike C1http://sqlblog.com/blogs/michael_coles/comments/19010.aspxhttp://sqlblog.com/blogs/michael_coles/commentrss.aspx?PostID=19010http://sqlblog.com/blogs/michael_coles/rsscomments.aspx?PostID=19010Back in January 2007, SQL guru Itzik Ben-Gan posted a series of MS Connect enhancement requests concerning windowing function enhancements. Those who have used the ROW_NUMBER() , RANK() , DENSE_RANK() , and NTILE() functions on SQL 2005 and 2008, you...(<a href="http://sqlblog.com/blogs/michael_coles/archive/2009/11/19/please-vote-windowing-enhancements-in-sql-server.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=19010" width="1" height="1">analytic functionsdatabasedbadense_rankdevelopmentfunctionsmsdnmvpntileoptimizationoverover clauseprofessionalsprogrammingqueryrankrow_numberSQLsql 2005SQL 2008t-sqlwindowing functions