TR_APPEALDESIGNATION_UPDATE

                    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