Thanks Ron for the QoTD. Today, I've learned that "TOP WITH TIES" returns ties only iff the last row is tied. Darn, all along, I was thinking TIES works on all rows.;-)

Its too bad, I have to go back and check all the hundreds of procedures. 🙁 But I think it should not function like it, rather it should work on all tied rows.