Hi all, I have set up my database where information will be imported monthly and a report is generated. Each monthly reports might contain information from the previous months and I would like to have those duplicate entries deleted.
I am thinking of having a master table and a temp table where the import information would go and then have a check put into place to sort those entries out. However, I am not sure how to proceed with this implementation. Please help, thanks in advance.
I am thinking of having a master table and a temp table where the import information would go and then have a check put into place to sort those entries out. However, I am not sure how to proceed with this implementation. Please help, thanks in advance.