Solved

RANK() functionm in SQL 2000

Posted on 2006-07-20
3
1,582 Views
Last Modified: 2011-10-03
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
0
Comment
Question by:msmid
  • 2
3 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 125 total points
ID: 17145943
RANK is only available as from SQL Server 2005
0
 
LVL 23

Expert Comment

by:apresto
ID: 17145949
Hi msmid,

I think rank() is only available in 2005

Apresto
0
 
LVL 23

Expert Comment

by:apresto
ID: 17145954
sorry for the dup angel - your too damn quick :o)

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

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SELECT query on two levels (detail and summary) 13 47
SQL Server Designer 19 39
Need some help to cast ntext to nvarchar SQL 2000 7 31
Can > be used for a Text field 6 35
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now