How often is the table going to be inserted into?

But a simple insert trigger would do the job, if the inserts are very few and far between.

CREATE TRIGGER ..... ON .....

FOR INSERT

AS

INSERT INTO .....

SELECT .....

FROM

INSERTED

UPDATE ....

SET ... = ....

FROM ...

INNER JOIN

INSERTED

ON ... = ...