urgently need dynamic SQL to compare corresponding columns data content
Posted on 2003-03-19
question to ScottPletcher, et al - in a previously posted question "Title: Temp tables compare" (From: kumaranCN), scott replied:
>>If you wanted to, you could generate dynamic SQL to compare corresponding columns, that is, the first column on table1 to the first column on table1, the second column on table1 to the second column on table2, etc.. If you interested in that, please post a message stating that and I will code it up and post it.
I am interested in a dynamic column-wise comparison sql that will compare content of corresponding columns between 2 similarly metadata-structured tables
Any chance if you could please code up and post such an example?