Looking for Business Logic to Handle the Sql Query in proj

Question

Hi Team  I m doing a project where i what to trasfer lead/Activity of one Emp to other emp(if left the Job). where i want just change empId of that perticuler LeadID . after this we will tack the update on that LeadID . Looking logic how i will handle this

Nilesh Shah · Answer

lets say your leads table has its PK leadId and EmpId and other columns when change is required just change the EmpId to new id in place of old emp id using a stored procedure. you can also store the old leadid and old empid in one history table to keep track of what was changed