Trigger dbo.D_Period_UTrig

CREATE TRIGGER D_Period_UTrig ON D_Period FOR UPDATE AS
/ *
* CASCADE UPDATES TO ´D_GLJournal´
* /
IF UPDATE(DocPeriod)
BEGIN
UPDATE D_GLJournal
SET D_GLJournal.DocPeriod = inserted.DocPeriod
FROM D_GLJournal, deleted, inserted
WHERE deleted.DocPeriod = D_GLJournal.DocPeriod
END

/ *
* CASCADE UPDATES TO ´D_GLJournalItem´
* /
IF UPDATE(DocPeriod)
BEGIN
UPDATE D_GLJournalItem
SET D_GLJournalItem.AllocPeriod = inserted.DocPeriod
FROM D_GLJournalItem, deleted, inserted
WHERE deleted.DocPeriod = D_GLJournalItem.AllocPeriod
END

/ *
* CASCADE UPDATES TO ´D_GLSum´
* /
IF UPDATE(DocPeriod)
BEGIN
UPDATE D_GLSum
SET D_GLSum.DocPeriod = inserted.DocPeriod
FROM D_GLSum, deleted, inserted
WHERE deleted.DocPeriod = D_GLSum.DocPeriod
END