September 14, 2017 at 1:11 am
Good Morning Experts,
The developers were updating a column with different value each day from past 10 days. Now, they are asking to provide values that got updated for the column over the last 7 days. How to accomplish this?
September 14, 2017 at 2:42 am
Are you saying you want a history of the values that were in the table? Unless you've been storing these somewhere (for example an audit/history table, slowing changing Dimension in a Data Warehouse using your source table, temporal table), then you're going to be out of luck. If you do, you'll know where that is stored.
If this is going to be a requirement going forward, and you don't have anything, I'd recommend you set up a audit/history table. It's up to you how to set it up, save off old data to a different table before updating the production, making a full copy of the table at the end of each day into another (make sure everything is date stamped what ever option you choose), but you'll need something to be able to see what data you previously had.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply