I am comparing data in 2 identical tables and retuning rows that have columns with wrong data.
In the moment I am selecting all columns and have to look through all of them to find not matching ones.
I'd like to create additional column that will have a list of not matching columns names.
Any ideas how to implement it in sproc?
What are other choices?