Comparison of Two Huge List SQL or .Net or ExcelHi,
I have two huge list say
StagingList containing 130K records and ProdList containing 129K records.
Could you please let me how to compare and find
1. records that exist in StagingList not in Prod List
2. records that does not exist in stagingList but exist in Prod List.