ce mai vorbesc singur pe aici :)))))))))))).....dar tot e bine ca se rezolva lucrurile :)

alex. 

Edit...am gasit varianta cea mai simpla.... ca de obicei varianta cea mai buna si simpla o "vad" ultima :)

CREATE TRIGGER [trg_Equival_INSERT_UPDATE] ON [dbo].[EQUIVAL]
FOR INSERT,UPDATE
AS

if ((select trigger_nestlevel(object_id(N'[dbo].[trg_Equival_INSERT_UPDATE]')))=1)
BEGIN
declare @CURIDREF as int ,
     @RATEDATE as datetime ,
     @CURID as int

select @CURIDREF = curidref, @RATEDATE = ratedate, @CURID = curid from inserted

If Not Exists(SELECT * FROM A..EQUIVAL WHERE curidref=@CURIDREF AND
ratedate = @RATEDATE AND curid = @CURID)

     begin
      insert into A..EQUIVAL (curidref,ratedate,curid,purchaserate,fixingrate,salesrate)
      select curidref,ratedate,curid,purchaserate,fixingrate,salesrate from inserted
      end
else
     begin
      update a
      set a.purchaserate = i.purchaserate, a.fixingrate = i.fixingrate, a.salesrate = i.salesrate
      from A..EQUIVAL a, inserted i
      where a.curidref = @curidref and a.ratedate = @ratedate and a.curid = @curid
     end
END
GO