SQLServerCentral / Integration Services / Data Warehousing / how to do sum the salarie of employes if empnames are equal in ssis / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 19:08:05 GMT20RE: how to do sum the salarie of employes if empnames are equal in ssishttp://www.sqlservercentral.com/Forums/Topic1033302-364-1.aspxHere is a GROUP BY solution[code="sql"]CREATE TABLE #T(EmpId INT, EmpName VARCHAR(50),Salary MONEY)INSERT INTO #TSELECT 123, 'andy', 10000 UNION ALLSELECT 111, 'Maddy', 12000 UNION ALLSELECT 121, 'Raman', 25000 UNION ALLSELECT 124, 'Hemanth', 40000 UNION ALLSELECT 133, 'krishna', 50000 UNION ALLSELECT 122, 'andy', 20000 UNION ALLSELECT 134, 'Raman', 60000 UNION ALLSELECT 143, 'Maddy', 30000SELECT SUM(Salary),EmpName FROM #T GROUP BY EmpNameDROP TABLE #T[/code]Sat, 11 Dec 2010 10:15:42 GMTbitbucket-25253RE: how to do sum the salarie of employes if empnames are equal in ssishttp://www.sqlservercentral.com/Forums/Topic1033302-364-1.aspxLooks like homework... You might want to look into aggregation task or GROUP BY in TSQL.Sat, 11 Dec 2010 10:03:05 GMTLutzMhow to do sum the salarie of employes if empnames are equal in ssishttp://www.sqlservercentral.com/Forums/Topic1033302-364-1.aspxHi All,if employee names in a table are equal then that particular employees salary should be add total, Here i am giving one simple example:input table is as below:EmpID, EmpName, Salary123, andy, 10000111, Maddy, 12000121, Raman, 25000124, Hemanth, 40000133, krishna, 50000122, andy, 20000134, Raman, 60000143, Maddy, 30000the output should be like:EmpID, EmpName, Salary123, andy, 10000122, andy, 20000143, Maddy, 30000111, Maddy, 12000121, Raman, 25000134, Raman, 60000124, Hemanth, 40000133, krishna, 50000EmpName, Salaryandy, 30000Maddy, 42000Raman, 85000Hemanth, 40000krishna, 50000Sat, 11 Dec 2010 06:56:47 GMTjeevan.gumpu