Solved

RANK() functionm in SQL 2000

Posted on 2006-07-20
3
1,600 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 143

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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

752 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