Did you check what the select total(dauer)... returns before stuffing it into the trigger program? Did you check what select *... returns to see the records that match the criteria? You could also try dropping the trigger, doing the insert, and checking that the SELECT from the trigger produces a result.