|
allan8964
Posting Yak Master
202 Posts |
 Posted - 12/25/2012 : 13:49:32
|
Hi there,
I have table1 which has some raw data processed and saved in table2. Now I need to compare the data from these 2 tables by running different stored procedures, to see if they match. If yes then pass, if not then save the error and the different results fom comparison. I run exec sp1 param1, param2 to get results from table2 and runn exec sp2 parameter1, parameter2 ... to get results from table2. The results columns could be different, see follwoing: but the bold ones are the ones to be compared:
result1: ...ID, Code, Model, Num, ... Date
result2: ...ID, Name, Model, SerialNum, Date
Model and Date must be compared and if they're not match then I need save the ID and different values for Model and Date, in a third table. How can I do this? Thanks in advance and Merry Christmas!
|
|
compare 2 results and save unmatched records
