Stored Procedure for SCD type 2 implementation

Generic Stored Procedure that implements SCD type 2 using MERGE and UPSERT(INSERT + UPDATE)
Timeline:
00:30 SCD type 2 introduction
01:31 Github code
01:57 SCD type 2 example
05:08 Terminologies used
06:22 INSERT and UPDATE impl. SCD type 2
11:50 Merge impl. SCD type 2
17:52 Demo

Github: https://github.com/ZosBHAI/SQL-Cookbook/tree/master/sqlserver/SCDType2

Видео Stored Procedure for SCD type 2 implementation канала Cubicle Tech Notes