Has probado asi?
Código SQL:
Ver originalSELECT *
FROM estadistico e
WHERE e.idProRep IN (@Pro)
AND e.fechaRegistro >= @Fechainicial
AND e.fechaRegistro <= @Fechafinal
AND e.IDPRO IN (@Pro)
AND NOT EXISTS (
SELECT 1
FROM TipoAct ta
INNER JOIN Actuacion a ON ta.idTipoAct = a.idTipoAct
WHERE ta.idEstado IN ('793448457', '795601556', '958298478')
AND e.idCaso = a.idCaso
)