I have a 3rd normal form table which maintains history over time using a date row start and date row end.
I need to extract data incrementally from this table starting at 1900-01-01 and looping through each day. The easiest way is to provide the data and use it in a where clause like this:
WHERE '1900-01-01' between date row start and date end date
incrementing the date by a day then running the query again. However this would obviously pick up the same records time and time again. This isn't neccessary a issue as I will be merging these 'incremental' records using a column . It will only be a one off data load operation. But from a performance I would like to think of other ways to access that data.
I cannot change the structure of the source table and there are no other dates I can use.