When querying a database table, the result set is typically consistent with the current time, that is, at the time the query is ... couple additional columns of datetime2 data type, the VALIDFROM and ...

WHILE loop performance in SQL Server ... a query on the base table for each record returned. Also, the use of an ORDER BY statement is necessary, as is the use of a primary key column.