I have a DTS package that runs a stored procedure to populate an employee table, what I want it to do is overwrite the existing table once a week or only add new employees and remove old. I figured the easiest way was to just rebuild the table each week, thus accomplishing all the tasks, but everytime I run it it just appends here is the stored procedure: Select * from mastEmployee where inactive='1'; This is set to copy from one table to another, but I want it to overwrite or update my second employee table.
Thanks in advance