Hi All,
I have a table "TestCaseMaster" which consists of column "RunInTA" which is of datatype bit. I have added new column "DisableDate" which is of datatype datetime.
Whenever the value of RunInTA is updated, the timestamp has to be captured and updated in the column DisableDate.
For example: For TestCaseID 1, if RunInTA is updated from 1 to 0 on 7thJune2021 at 10.00.00 then the value of the column DisableDate for TestCaseID 1 should be "210607 10:00:00"
Please let me know what is the best way to this functionality in SQL.
Kindly waiting for your response.
Thanks,
Santosh

