I Need Help With A RANK() Issue

This query:

SELECT xx.JumpHeight, xx.HeightRank, xx.NoEvents, xx.MinRunDate, xx.DogIdent,

Dogs.CallName, DogOwner.LastName, DogOwner.FirstName

FROM

(SELECT JumpHeight, DogIdent, MIN(RunDate) as "MinRunDate", COUNT(Event_ID) AS "NoEvents",

RANK() OVER (PARTITION BY JumpHeight ORDER BY COUNT(Event_ID) DESC, MIN(RunDate)) AS "HeightRank"

FROM EventData

WHERE Event=@Event

GROUP BY JumpHeight, DogIdent) AS xx, Dogs, DogOwner

WHERE (Dogs.Breed = @Breed AND xx.DogIdent = Dogs.DogIdent and Dogs.Owner_ID = DogOwner.Owner_ID) AND

(xx.HeightRank <= 10)

ORDER BY xx.JumpHeight, xx.HeightRank


produces this output:





Jump Ht.

Rank

# of Events

First Event

Owner

Call Name


08

3

1

2/19/2006

Some Owner

Otto


08

4

1

3/12/2006

Some Owner

Schotzie

I want it to produce this output:





Jump Ht.

Rank

# of Events

First Event

Owner

Call Name


08

1

1

2/19/2006

Some Owner

Otto


08

2

1

3/12/2006

Some Owner

Schotzie

I have tried several things and cannot correct the problem. Obviously, RANK is being evaluated in the wrong place, but placing it elsewhere has failed to produce the above results.

I appreciate any help I can get. Thanks!