I have 2 records that I want to run the MINUS command against.
The first record is a listing of "brand new" data. The second record is a compilation of all the "brand new" data that has already been processed.
I know how to easily generate the data... IE....
Select A, B, C, D from X
Minus
Select A, B, C, D from Y
What I'm wondering, is there a way for the code to tell me that D or C were the fields that didn't match up?
My 2 records have 34 fields and, when I have to do an update, the coding is going to be long and a pain.
Any tips or tricks to shorten this process?
Thanks for your time!