CREATE trigger TR_APPEALDESIGNATION_UPDATE on dbo.APPEALDESIGNATION after update not for replication
as begin
if update(ISDEFAULT)
begin
if(select count(ID) from INSERTED where ISDEFAULT = 1) > 0
begin
/*If the record being updated 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
end
end
|
Trigger Definition
