TR_FENXTINTEGRATION_IU

                create trigger TR_FENXTINTEGRATION_IU
                on dbo.FENXTINTEGRATION
                for update, insert
                as
                if update(FEDESIGNATIONSOURCE)
                    begin
                        --only one allowed as the source.  Pick one

                        declare @FIRSTINTEGRATIONID uniqueidentifier;
                        declare @CHANGEAGENTID uniqueidentifier;

                        select top 1 @FIRSTINTEGRATIONID = ID, @CHANGEAGENTID = ADDEDBYID
                        from inserted where FEDESIGNATIONSOURCE = 1;

                        if (@FIRSTINTEGRATIONID is not null)
                            begin
                                update dbo.FENXTINTEGRATION
                                set FEDESIGNATIONSOURCE = 0,
                                DATECHANGED = getdate(),
                                CHANGEDBYID = @CHANGEAGENTID
                                where FENXTINTEGRATION.ID != @FIRSTINTEGRATIONID;
                            end
                end