Dealing with new data for a type 2 slowly changing dimension using SQL
Here's a step-by-step guide for dealing with a Type 2