Rowan-283474 (8/23/2016)
Rowan-283474 (8/23/2016)
Sergiy (8/23/2016)
Sergiy (8/22/2016)
Do you really have the case when the source table does not have any kind of time stamp or an auto-incremental ID?Can you answer this?
Yes unfortunately I have nothing like the above mentioned to work with
I do actually have a timestamp that I can work with but this doesn't help me when it comes to identifying rows that I need to update on my side, without some for of an ID or Key column.
If that time stamp indicates the time when a row was last time affected with an insert/update then you need to copy only those rows which have the time stamp later than the MAX(time stamp) in your reporting data set from yesterday.
_____________
Code for TallyGenerator