MERGE clause detecting changes but not inserting latest values
I am trying to implement SCD type 2 using MERGE clause in SQL SERVER. I have written the following code:
I am trying to implement SCD type 2 using MERGE clause in SQL SERVER. I have written the following code: