>This command gives a deadlock error about 3 times out of 50000 hits:
>
>

>DECLARE @NoMember Integer
>DECLARE @LastAccess DateTime
>
>SET @NoMember=64631
>SET @LastAccess='2009-02-11 11:46:55'
>
>SELECT Member.Numero,Member.Nom,Member.Prenom,Member.LastAccess
> FROM (SELECT Monitor.NoMember2 FROM Monitor WHERE Monitor.NoMember=@NoMember) Temp
> INNER JOIN Member ON Temp.NoMember2=Member.Numero 
> WHERE Member.LastAccess>=@LastAccess ORDER BY 2
>

>
>This line also executed within about 0.00 second. So, what can cause this behavior?

BTW, why do you use this strange select, why not INNER JOIN? Does it work better than INNER JOIN with Monitor?

Or using WHERE EXISTS select query?