Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
UPDATE Table2 SET username = Table1.username , computer = Table1.computer , status = Table1.status , IP = Table1.IP , MAC = Table1.MAC , Time01 = Table1.time01 FROM Logonoff2 JOIN Table1 ON Table2.username = logonoff_all.username and Table12.computer = Table1.computer and Table1.status = Table2.status and Table1.time01 > Table2.time01 INSERT INTO Table2 (Username, Computer, Status, IP, time01) SELECT Table1.username, Table1.computer, Table1.status , Table1.IP, Table1.time01 FROM Table1 WHERE NOT EXISTS ( SELECT null FROM Table1 WHERE Table2.userName = Table2.username and computer.Table2 = Table1.computer)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.