It works now. As you said the trick was in Partition BY clause to restart the ranking.. Awesome!! Thanx a lot..

Thanx for everyone's input. Appreciate it.

Thanks. I am new at this cursor and trying to modify someone else code so that it run faster. I wonder why would someone use Cursor if we can do...