Dealing with Type 1 Slowly Changing Dimensions in SQL
Here's a step-by-step guide on dealing with a Type 1