SQL Update on date > = other table Date

So if understand this correctly, the entry select 1001,3,'2012-01-01','2012-06-01' overrides the previous ...

social.technet.microsoft.com