Sample Header Ad - 728x90

Insert Timestamp on value change from other table

0 votes
1 answer
798 views
I have an EvidenceTimeStamp table that is triggered with data when the case table has data inserted into it. EvidenceTimeStamp: - CaseID - EvidenceNum - EvidenceType - Evidence_Initiated_Timestamp - Evidence_Returned_Timestamp I created a trigger to fill the first four columns of data whenever a new case is inserted in the case table and it creates a timestamp on Evidence_Initiated_Timestamp when this happens. However, I need to create a closing timestamp when the process is complete. I wanted to do this by my Outbound Ship Table- everytime the Attribute (bit value) Outbound_Item_Recevied is changed from false to true (or 0 to 1) I want it to initate a timestamp on the Evidence_Returned_Timestamp column in my EvidenceTimeStamp table that matches the corresponding CaseID and EvidenceNum. Note: the EvidenceTimeStamp table does not have a primary key or foreign key technically... the CaseID is primary key in the Case table and EvidenceNum is an attribute in the Evidence Table. This is a "trigger" table so it really doesn't have its own specific data, it's just filling data from other tables. Any idea of how to do this? Also, other quick question, how do I get bit values to show "True" or "False" instead of 1 or 0? Thank you!!
Asked by Alee (47 rep)
Jun 8, 2017, 03:10 PM
Last activity: Aug 6, 2025, 07:09 AM