Trigger varios consecutivos

[defcon1_es]

Prueba así:

Código SQL [-]
CREATE trigger corresp_ai0 for corresp
active before insert position 0
AS 
begin   
  Select Max(Consec)+1 
  from Corresp 
  Where Usuario=Old.Usuario
  into New.Consec;
end