Experts, I have 2 tables with the same structure but not the same data. I want to compare these 2 tables to see what is different between them. I am importing data from excel and made a temp table before Inserting the new data. I am comparing the temp table with the newer table of imported data. I am not sure if there is some simple way to do this i/o writing a query comparing the 2 tables.
I am using 2007.