NAME Emp_ID Points TotalPoints ABC 1 50 0 ABC 1 40 0 XYZ 2 20 0 LMN 3 30 0 LMN 3 50 0 XYZ 2 10 0 LMN 3 5 0
NAME Emp_ID Points TotalPoints ABC 1 50 90 ABC 1 40 90 XYZ 2 20 30 LMN 3 30 85 LMN 3 50 85 XYZ 2 10 30 LMN 3 5 85
UPDATE dst SET dst.TotalPoints= src.TotalPoints FROM YourTable AS dst INNER JOIN ( SELECT Emp_ID, SUM(Points) AS TotalPoints FROM YourTable GROUP BY Emp_ID ) AS src ON dst.Emp_ID = src.Emp_ID
UPDATE Points SET TotalPoints = tot FROM Points p INNER JOIN (SELECT Emp_ID, SUM(Points) AS tot FROM Points GROUP BY Emp_id) t ON t.Emp_ID = p.Emp_ID
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)