Title: select insert into orbits actatek-IN                                 If you need copy same format use firefox or chrome or safari but iexplorer not work


Preview of Code
 INSERT OPENQUERY (HR12, `SELECT  ID ,EMPID,DEPARTMENT,EVENTID,TERMINALSN,RECLOGFROMIP,LOCAL_TIMESTAMP_DATE,
LOCAL_TIMESTAMP_TIME,PARM
                FROM HRGVUSER.T_HRGV_EVENT_LOGS`)
select  i.id,
                 i.USERID,
                 i.DEPARTMENT ,
                 i.EVENTID,
                 i.TIMESTAMPS,
                 i.RECLOGFROMIP,
                 i.LOCAL_TIMESTAMP,
                 i.LOCAL_TIMESTAMP,
                 i.parm
 from   access_event_logs i
 where   CAST(LOCAL_TIMESTAMP  AS DATE)=`2016-06-16`  and EVENTID=`IN`