try this to get ids which are existing wrongly.SELECT *FROM(SELECT *,SUM(AMOUNT) OVER (PARTITION BY ID) AS TotalFROM TBL_Account)tINNER JOIN TBL_CH cON c.ID = t.IDWHERE c.AMOUNT <> t.Total
once you're staisfied with returned records. you can use below logic for insertionINSERT INTO TBL_AccountSELECT t.ID,c.AMOUNT - t.TotalFROM (SELECT ID,SUM(AMOUNT) AS TotalFROM TBL_AccountGROUP BY ID)tINNER JOIN TBL_CH cON c.ID = t.IDWHERE c.AMOUNT <> t.Total
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/