Yep, that's right. I didn't want to use my real name, so I decided to select an alias from one of my favorite books.

You're the first person who's ever commented on the name, but then I don't post a whole lot of questions. I'm also known as Demerzel on other sites. ...

This worked perfectly! In case there's anyone else out there who's never used this function before, here's the statement that I used:

DENSE_RANK() OVER (ORDER BY Value1, Value2) AS CURRENT_RANK

There's...

I'll do that. Thanks!

Thanks for the tip. I was able to get it done.

Hari

Thanks for the tip. CTEs are new with SQL Server 2005, aren't they? Most of my work has been with 2000, so I've never used them. I'll...