Loading

Looking for Business Logic to Handle the Sql Query in proj

Anurag Kulshrestha

9y776

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Shah9y ago
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