>>

>>select * from (select T.Numero, T.Title, T.Url, T.AddDate, row_number() 
>>over (partition by R.NoThread order by R.NoThread) as Row from Thread T LEFT JOIN Reply R on T.NoThread = R.NoThread where T.NoMember = @NoMember) X 
>>where Row <=10
>>

>
>This query takes very long so I had to stop it. There must be something in it which is not properly performed.

Weird....