Relative Content

Tag Archive for sqlsql-serverdatabasequery-optimizationscd

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.