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


Preview of Code
SELECT      TA_UID, TA_Timestamp, TA_ZoneID, TA_AccessPointID, TA_AuthenticationResult, TA_AuthorizationResult, TA_UserID, TA_UserFirstName, 
                      TA_UserLastName, TA_IDContext, TA_IDFactor, TA_ExtendedData, TA_LocalTimestamp, TA_Info, Transferred, TA_BCName, TA_UserFlexID 
FROM         TBST_TARecords  where CAST(TA_LocalTimestamp AS DATE)=`2016-06-16 ` and TA_IDContext=100 and TA_UserID is not null
 
 
    
INSERT OPENQUERY (HR12, `SELECT  ID ,EMPID,EVENTID,TERMINALSN,RECLOGFROMIP,LOCAL_TIMESTAMP_DATE,LOCAL_TIMESTAMP_TIME FROM HRGVUSER.T_HRGV_EVENT_LOGS`)
select  i.[TA_UID],
      i.[TA_UserID],
        `IN`,
    i.TA_Timestamp,                        --i.[TA_IDContext],
        i.[TA_AccessPointID],
        i.[TA_LocalTimestamp],
        i.[TA_LocalTimestamp]
 from  TBST_TARecords i 
 where CAST(TA_LocalTimestamp AS DATE)=`2016-06-16 ` and TA_IDContext=100 and TA_UserID is not null