no need of self join use group bySELECT EmployeeID,Name,[Year_],[Week_],[Contract_],SUM(BH) AS BH,SUM(OT1) AS OT1,SUM(OT2) AS OT2,SUM(OT3) AS OT3,MAX([PayType1_]) AS [PayType1_],SUM(PT1) AS PT1FROM TableGROUP BY EmployeeID,Name,[Year_],[Week_],[Contract_]
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs