Hi Perry,
Thanks for getting back - in reality I just need to check that data in a single column is the same for each matching PK in the 2 tables.
So each table as an ID and an EffectiveEndDate column - each table will have the same number of rows - approx 1.5 billions rows. They should be a copy of each other but I need to ensure for each row has the same value for EffectiveEndDate in both tables,
Thanks again for your reply,
JK