Comparing rows data in a table in SQL Server
I have a table with more than 80 columns. Table is based on a SCD, which means if there is any change in the value of any of the columns, I insert a new row with the change only in that column, rest of the values remain same.