<div>
Hi msmid,<br />
<br />
I think rank() is only available in 2005<br />
<br />
Apresto
</div>


Hi msmid,

I think rank() is only available in 2005

Apresto

<div>
sorry for the dup angel - your too damn quick :o)<br />
<br />
extra info anyway: &nbsp;<a href="http://support.microsoft.com/?id=186133" rel="ugc">http://support.microsoft.com/?id=186133</a>
</div>


sorry for the dup angel - your too damn quick :o)

extra info anyway:  http://support.microsoft.com/?id=186133 [http://support.microsoft.com/?id=186133]

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
when I'm trying to use RANK() function in SQL 2000 I get an error [Microsoft][ODBC SQL Server Driver][SQL Server]'RANK' is not a recognized function name.<br />
<br />
SELECT RANK() OVER (PARTITION BY Name ORDER BY Name) AS Rank, FolderId FROM Folder<br />
<br />
Mitja
</div>
</div>


Hi,

when I'm trying to use RANK() function in SQL 2000 I get an error [Microsoft][ODBC SQL Server Driver][SQL Server]'RANK' is not a recognized function name.

SELECT RANK() OVER (PARTITION BY Name ORDER BY Name) AS Rank, FolderId FROM Folder

Mitja

RANK() functionm in SQL 2000

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.