Okay. I think I got it. Here is what the code actually looks like (its a bit more complex than the sample data I originally gave)

If @varAI >0

BEGIN

SET ROWCOUNT @varAI

Insert...

David's code looks like it will work great. My one problem is that, in fact, the larger data set is not ordered ASC by ID and DESC by Popularity, rather...

If a is related to b, then b will be related to a.

Strictly speaking, if a is related to b and b to c, a is not necessarily related to...

Thanks for all the suggestions. I am actually looking to include related results but only one result from the related, not both. So I am not looking to exclude the...

No, they're not always related. And even if they are related, there might not be any relationship data available for them.

David.