Alex A
asked on
T-SQL query, comparing data in two tables
Hi,
I am comparing data in two identical tables, Ideally the data should be the same but there are some differences. I found those rows which are different using EXCEPT (there are multiple ways to do this).
If the row has not matching data then: some of this row columns have the same data and some have not the same data.
I'd like to write sql code that for every not matching row returns a list of not matching columns.
Thanks.
I am comparing data in two identical tables, Ideally the data should be the same but there are some differences. I found those rows which are different using EXCEPT (there are multiple ways to do this).
If the row has not matching data then: some of this row columns have the same data and some have not the same data.
I'd like to write sql code that for every not matching row returns a list of not matching columns.
Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.