title: Trigger not working properly on batch update
body: <p>I have a trigger that check data before insert to another table</p>
  
  <pre><code>  IF NOT EXISTS (SELECT *
                   FROM   inserted,
                          Clients
                   WHERE  Inserted.Account = Clients.Account)
    BEGIN
        INSERT INTO Clients(GUID, Account, ....)
        SELECT GUID, Account
        FROM   inserted
    END 
  </code></pre>
  
  <p>it's working fine if one row updated
  but if use batch update its not working.</p>
  
  <p>for example <code>Update Table1 set Number = Number where account &lt;&gt; ''</code><br>
  If the second table (Clients) is not empty, nothing added<br>
  if it's empty its work well</p>