Jeff,

I was talking about your solution:

SELECT ROW_NUMBER() OVER (PARTITION BY Link ORDER BY Li....

Others are not as good.

As for reason for this, when I was asked for it I, had...

I was looking for something similar to this post as well and your solution is the best - a keeper for future reference. Thank you very much. FT