I have a table that uses a trigger to save changes (old values) to a history table. This process is working fine, and I have reports that detail the history of a record for the end user.
My problem is that the end user now wants a report that will retrieve how the record looked at a specific date/time.
Id First Last Active Date
1 John Doe 1 10/25/2010
2 Jane Smith 1 10/25/2010
Id SourceId First Last Active Date
1 1 Jonathon NULL NULL 5/1/2000
2 2 NULL Gray NULL 10/1/2000
3 2 NULL Smith NULL 6/15/2003
4 2 NULL Doe NULL 11/23/2008
If the user queries for SourceId 2 on 1/1/2009, they need to get:
Id First Last Active
2 Jane Smith 1
I've used COALESCE searching multiple fields, but I need to figure out how to
View Complete Post