I'm just gonna let the nightly import via DTS run and then set up a job to check for and delete the older record. This is the stored procedure...

Thanks for all the input. I think I got it! Thanks again everyone.

I can delete the duplicate records, but what I need to do is delete the current record in favor of the imported record when the primary field already exists...

That works great. Thank you!!

--For this example, I am using a limited set of data and have not included all of the columns.

CREATE TABLE Test (KeyID char(6), [DateAdd] smalldatetime, DateClose smalldatetime, Nothing...

Thanks for the help. Can you provide any how-to steps?

Jan,

As angry as you are I still appreciate your efforts; however, your suggestion still does not work.

The data used for this question was Northwind because it is a database we...

Jan,

I appreciate your effort and glowing positive attitude; however, your suggestion does not work. This is apparent without the need of examining the data in Northwind. Here is your...

What would be the syntax for a rename instead of a delete?

Thanks for the input.

Hi Jeff,

Jan's solution did not work.  I appreciate her effort.

both

SOLUTION

SELECT

EmployeeID

,LowFreight

,(

SELECT count(*) FROM Orders PS

...

SOLUTION

SELECT

EmployeeID

,LowFreight

,(

SELECT count(*) FROM Orders PS

...

Thank you!!

I would agree that it would be annoying if I posted this question twice in this forum, but I didn't. This site has two forums for T-SQL. One...