Yes I think this is pretty close, I want the amended and new records in a NEW File

oops did not see the second page

That is the question so basically we need to compare record-by-record and ignore the duplicates and then insert changed records into that new file that is the requirement

will ANY of the records imported from Nov file have been altered when you get the Dec file? - Yes the member file records are modified and that is already...

J Livingston SQL (1/10/2016)

---

So let me rephrase the question

We would take the full file (Dec file) , compare/ check it to prior records imported (Nov file) and...

Eirikur Eiriksson (1/10/2016)

---

Here is a quick example to help you get started.

😎

Note: do not make the mistake of using functions on the date column in the where clause, forces the...

Thanks Hugo, Not sure if this is TSQL or ETL question so posted on both, please advise ?

So let me rephrase the question

We would take the full file (Dec...