CREATE TRIGGER CalcLastPrice AFTER INSERT, UPDATE, DELETE
ON "A"
REFERENCING NEW AS NewValue OLD AS OldValue
FOR EACH ROW
BEGIN
  DECLARE @goodsgrpip unsigned int;
  DECLARE @dateedit timestamp;
  DECLARE @price money;

  SET @goodsgrpid = IF INSERTING THEN 
      NewValue.goodgrpid
    ELSE 
      OldValue.goodgrpid
    ENDIF;

  SELECT dateedit, price
  INTO @dateedit, @price
  FROM A
  WHERE goodgrpid = @goodgrpid AND
        dateedit = (
          SELECT Max(dateedit) 
          FROM A 
          WHERE goodgrpid = @goodgrpid )


  UPDATE B
  SET dateedit = @dateedit,
      price = @price
  WHERE goodgrpid = @goodgrpid;

  IF @@ROWCOUNT =  0 
  THEN
    INSERT INTO B (goodsgrpid, dateedit, price)
    VALUES (@goodsgrpid, @dateedit, @price);
  END IF;
END;

CREATE TRIGGER CalcLastPrice AFTER INSERT, UPDATE, DELETE
ON "A"
REFERENCING NEW AS Inserted OLD AS Deleted
FOR EACH STATEMENT
BEGIN
  INSERT INTO B WITH AUTO NAME ON EXISTING UPDATE
    SELECT goodsgrpid, dateedit, price
    FROM A a
      INNER JOIN (
        SELECT goodsgrpid, Max(dateedit) AS last_dateedit
        FROM A
        GROUP BY goodsgrpid
      ) AS l ON l.goodsgrpid = a.goodsgrpid AND
                l.last_dateedit = a.dateedit
    WHERE a.goodsgrpid IN (
            SELECT goodsgrpid
            FROM Inserted
            UNION ALL
            SELECT goodsgrpid
            FROM Deleted );
END;