CREATE trigger TR_APPEALDESIGNATION_INSERT on dbo.APPEALDESIGNATION after insert not for replication
as begin
set nocount on;
/*if the inserted record is the default, unset default on all other records for this appeal*/
update dbo.APPEALDESIGNATION
set APPEALDESIGNATION.ISDEFAULT = 0,
APPEALDESIGNATION.DATECHANGED = INSERTED.DATECHANGED,
APPEALDESIGNATION.CHANGEDBYID = INSERTED.CHANGEDBYID
from INSERTED
where APPEALDESIGNATION.ID in
(
select APPEALDESIGNATION.ID
from dbo.APPEALDESIGNATION
inner join INSERTED on INSERTED.APPEALID = APPEALDESIGNATION.APPEALID
where APPEALDESIGNATION.ID <> INSERTED.ID
and INSERTED.ISDEFAULT = 1
);
end
|
Trigger Definition
