Trigger dbo.L_GLDept_DTrig

CREATE TRIGGER L_GLDept_DTrig ON L_GLDept FOR DELETE AS
/ *
* PREVENT DELETES IF DEPENDENT RECORDS IN ´D_GLJournalItem´
* /
IF (SELECT COUNT(*) FROM deleted, D_GLJournalItem WHERE (deleted.DeptCode = D_GLJournalItem.DeptCode)) > 0
BEGIN
RAISERROR(778416, 16, 1)
ROLLBACK TRANSACTION
END

/ *
* PREVENT DELETES IF DEPENDENT RECORDS IN ´D_GLSum´
* /
IF (SELECT COUNT(*) FROM deleted, D_GLSum WHERE (deleted.DeptCode = D_GLSum.DeptCode)) > 0
BEGIN
RAISERROR(778445, 16, 1)
ROLLBACK TRANSACTION
END