UPDATE t1 SET t1.Duration = (t1.Duration*12)/(select SUM(duration) from EmpTable where ECode=t1.ECode) FROM EmpTable t1, EmpTable t2
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)