>SELECT Client.Numero FROM Client WITH (NOLOCK) > WHERE Client.NoEntity=@NoEntity AND Client.Fic_Date<@Fic_Date > AND Client.Loss_Code=@Loss_Code AND Client.CType=@CType > AND EXISTS ( SELECT 1 FROM Invoice WITH (NOLOCK) WHERE Client.Numero=Invoice.NoClient > AND Invoice.Amount=@Amount) >Could you define "dirty reads"? Also, is the NOLOCK ANSI SQL compliant?