I have the following query:
SELECT [Exceptions].Employeenumber,[Exceptions].exceptiondate, [Exceptions].starttime, [exceptions].endtime, [Exceptions].code, datediff(minute, starttime, endtime) as duration into scratchpad3
FROM Employees INNER JOIN Exceptions ON [Exceptions].EmployeeNumber = [Exceptions].Employeenumber
where [Exceptions].exceptiondate between '10/2/2010' And '10/8/2010'
GROUP BY [Exceptions].Employeenumber, [Exceptions].Exceptiondate, [Exceptions].starttime, [exceptions].endtime,
[Exceptions].code, [Exceptions].exceptiondate
and I want to be able to add new data to my table. Is it best to use update or append and if so where should I put that command?
Thank you
Doug
Updating (or appending) existing data
Posted - 2011-01-18 : 11:46:42
