It would be great to be able to build views based on effective dated tables.

EmployeeID EffectiveDate Change
A 10-12-2010 ABCD
A 10-1-2011 jkebfbe
B 1-1-2011 lwqfwf
B 4-9-2012 kefkhk
C 5-3-2012 hkvhkg

I have no way to build a view that gives me the current rows for A, B and C