Stack Overflow
Stack Overflow

Questions tagged [history-tables]

In SAP HANA you can define a History Table. It keeps rows after (delete, update). So you can travel back in time if needed

10 questions
4
votes
0 answers

Prevent TypeORM from generating constraints

I am extending a class Entity to create a history table. The history table, must not inherit the unique constraints from the base class because we need to duplicate most of the data in there. Of course, I can just copy the properties without…
Andrew Radulescu
  • 1,862
  • 13
  • 21
2
votes
1 answer

SAP HANA History Tables when (not) to use, pros / cons

In SAP HANA we have the option to use History tables. So we can query / view the current values but can also view the table as of a specific date. More detailed explanations are here: SAP HANA History Table - Time traveling using SAP HANA When I…
Thorsten Niehues
  • 13,712
  • 22
  • 78
  • 113
0
votes
0 answers

Creating a Date Field based on conditions - Python

In python, I’ve set up a script that creates a table called ‘Today_DQ_Results’. It runs a few SQL queries and concatenates the results to a single dataframe. The script then pulls in the ‘Prior_Day_DQ_Results’ (i.e. results from yesterday),…
Benjamin
  • 29
  • 3
0
votes
0 answers

Merge replication with temporal table in SQL server 2019

I have a table with SYSTEM_VERSIONING=ON and trying to create Merge replication and facing issue. In Microsoft documentation it is mentioned as "Merge replication:Not supported for temporal…
Prabakaran Dhamotharan
  • 1
  • 1
0
votes
1 answer

Find original value for record using temporal and history table

In SQL Server, if you have a temporal table and a history table, how do you find the original values for a record if you do not know the date/time that record was first created? If the record was never edited, then it won't have a value in the…
OllieH
  • 3
  • 4
0
votes
1 answer

How to show the latest record for "each" month given only a date range of each records

I have a history table that contains the records of each customer with start_date and end_date columns that indicate validity period of each rows. The table looks like this: | ID | Name | Code |start_date (Timestamp) |end_date (Timestamp) | |:---…
Jojo10478
  • 29
  • 6
0
votes
2 answers

How to show the last record of each customer for each month?

Please help, I have a table that contains the history of changes of the customer`s record for the last 3 years. And I need to output the status or record of each customer for the "last day" of "each" month. The table looks like this: Table A: | ID …
Jojo10478
  • 29
  • 6
0
votes
0 answers

Error : "Cannot continue the execution because the session is in the kill state " when history table is enabled

We enabled temporal data (system-versioning history for table) on SQL Server 2017 but when we execute a delete command like below get an error message Cannot continue the execution because the session is in the kill state delete kelakets where…
sajjad
  • 646
  • 1
  • 9
  • 20
-1
votes
1 answer

How to maintain History for Truncate/Load Table in Oracle?

I have to maintain history into target table for each and every change made into source table.
Raunak
  • 13
  • 4
-3
votes
2 answers

How to select the rows with maximum timestamp for each month?

How can I select the maximum timestamp for each month?
hiro
  • 1
  • 1