TR_APPEALDESIGNATION_INSERT

                    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