Effective Dated tables
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
1
vote
![](https://secure.gravatar.com/avatar/b1e3241519c1ce51a1bf3e4f12a23bed?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)