Does anyone know where I can find documentation on the new SQL 2005 ranking function, specifically documentation that mentioned that "SQL 2005 will not allow any reference to ranking function in the WHERE clause"? I can't seem to find anything on Microsoft site? TIA