SQL code to remove duplicates from table then import into a existing table

[madamson86]

Hello

I am hoping someone is able to help me, I have setup a new database but need some assistance in setting up some SQL code which I havent done before.

I have two tables, one is linked to Sharepoint (Completions) and one is linked to an excel file (Import). I need to run a query that goes through the Import table and removes any duplicate lines where the [Matter Number] and [Completion Date] are the same so that only one line is remaining. Once this has been done I need to compare the import table against the Completions table and again remove any entries from the import file where the [Matter Number] and [Completion Date] already appear in the Completions table.

Then anything that is left in the Import table needs to be moved across to the Completions table.

Thanks in advance for your assistance.

Cheers
Mike

 

[alansidman]

Take a look at this video on deleting duplicates.

http://www.datapigtechnologies.com/flashfiles/duplicateproblem.html

Alan