title: Msg 4104, Level 16, State 1, Procedure AddItemToCurrentItems, Line 11 The multi-part identifier "INSERTED.IsActive" could not be bound
body: <p>I have following trigger written for my application which gives me this error "Msg 4104, Level 16, State 1, Procedure AddItemToCurrentItems, Line 11 The multi-part identifier "INSERTED.IsActive" could not be bound."</p>
  
  <p>My intension with this trigger is to copy the inserted data in table "Item" to table "CurrentItems" but only if the bit field in Items table is set to True i.e. 1. Both tables have the same table structure</p>
  
  <pre><code>CREATE TRIGGER AddItemToCurrentItems 
     ON ITEMS FOR INSERT
  --,UPDATE
  AS
  BEGIN
      -- SET NOCOUNT ON added to prevent extra result sets from
      -- interfering with SELECT statements.
      SET NOCOUNT ON;
  
      -- Insert statements for trigger here
      IF INSERTED.IsActive = 1
      BEGIN
         INSERT INTO CurrentItems
             SELECT * FROM INSERTED
      END
  END
  </code></pre>
  
  <p>Any ideas, what I am doing wrong here.</p>