When you want to retrieve temporal data that was valid at a given point in time, the resulting set could contain both actual and historical data. For instance, the following query would return all rows from the People temporal table in the WideWorldImporters sample database that were valid at 20th May 2013 at 8 A.M.:
SELECT PersonID, FullName, OtherLanguages, ValidFrom, ValidTo FROM Application.People WHERE ValidFrom <= '20130520 08:00:00' AND ValidTo > '20130520 08:00:00' UNION ALL SELECT PersonID, FullName, OtherLanguages, ValidFrom, ValidTo FROM Application.People_Archive WHERE ValidFrom <= '20130520 08:00:00' AND ValidTo > '20130520 08:00:00';
The query returns 1,060 rows. For a single ...