• Good catch.
     
    It should be
     
    insert into Call_Log_Event (call_log_id, event_desc, event_cd , eventdt, archivedt)

    select call_log_id, event_desc, event_cd , eventdt, getdate()

      from Call_Log_Event_Archive

      where datediff(dd,eventdt, getdate()) <= 10 

     
    I placed only an idea to show that many ways around to get better solution than the one (actually many people using) I described. Depend on the situation different decision may be taken. You are right.