I have a question:
PROBLEM: I have a Table A
with 100 columns Table B
with 100 columns but column names are not same for Table A and Table B.
I need to compare each column of Table A and Table B and if column value does not matched then insert that particular column name and value to some temporary table.
The comparison should be for each column not for row.
Can any one tell how to do it any technique are welcomed whether using Cursor or Procs.