trigger-1

create or alter trigger [SyncStatus]
on [Health]
after insert, update, delete
as
begin
    select
        [Current],
        [AnimatorID]
    into #ins
    from inserted
    where
        [Current] = 0

    insert into #ins([AnimatorID], [Current])
    select [AnimatorID], 0 from deleted

    declare @i int = (select count(*) from #ins);

    if @i > 0
    begin
        update [Animator]
        set [Status] = 0
        where
            Animator.ID in (select [AnimatorID] from #ins)

        update [Nickname]
        set [Status] = 0
        from
                       [Nickname]     as Nic
            inner join [AnimatorsNic] as ANic on Nic.ID = ANic.NicID
        where
            ANic.AnimatorID in (select [AnimatorID] from #ins)

        set @i = @i - 1;
    end

end