In the application they enter some values and then this trigger calculate some stuff en update a few things. That's to the best of my knowledge.

Apparently the first part of the trigger works most of the time. The second (last) part of it doesnt work always. So, no syntax errors, just logic errors.

They have...

Thanks for the help. I did not write the trigger (luckily). I'm the lucky guy who got the job to debug/fix it :/

Though, I really appreaciate your help. I hope...

CREATE TRIGGER [dbo].[D03D09] ON [dbo].[_rtblIncidents]

AFTER UPDATE, INSERT

AS

declare

@incidentID varchar(50)

set @incidentID = (Select idIncidents from inserted)

IF UPDATE (ulINCApproved)

BEGIN

UPDATE dbo._rtblIncidents

SET DAppr=dbo._rtblIncidents.ufINCSAmt+dbo._rtblIncidents.ufINCTCost

where idIncidents = @Incidentid and dbo._rtblIncidents.ulINCCat="3 Gold"

END

BEGIN

UPDATE dbo._rtblIncidents

SET...