Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Background:
Table 1:
ID | Name | Status |
---|---|---|
1 | test 1 | TBD |
2 | test 2 | TBD |
Historic data of Table 1:
Table 2:
ID | Change Date | Status |
---|---|---|
1 | 01/08/2015 | Change |
How can i join or concatenate additional data (Historic) to Table 2 based on change date. So historic table looks like
ID | Change Date | Status |
---|---|---|
1 | 01/08/2015 | Change |
1 | 07/08/2015 | Passed |
2 | 07/08/2015 | Change |
Hope someone can add some insight with an example.
Thanks,
I am not sure I understand, how did you arrive at the two new rows you added to your Historic Table??? Where is that information coming from???
The rows should populate based on record change. Means if record gets changed then i would like to keep both status into same table. Like snapshot.
Any insight how to build snapshot of the data if field value gets changed?