Once again , thanks.:-)

Wonderful SSCrazy, it's works now.

I was trying to solve the issue with the RANK notion, but i still looking. Anyway with the CROSS APPLY in your solution it's fine. I...

Hi SSCrazy,

There is misunderstanding about the rule business.

I am not talking about Highest value as you said, so 3 is not the default value.

As i said in the...

Hi SSCrazy Eights,

thanks for your answer, but the result is not that i suppose to get.

Your rersult:

NameA NameC

---------- ----------

AAA ...

Thank you Delconte for your answer, but it does not works, according to your query , we will get anytime the row with

id_c = 2.

But i want if...