quote:

---

Originally posted by nigelrivett

Why do you take the incentives 35.66 rather than 100?

both are different employeeids
==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

---

SELECT TOP 1 *
FROM #tempEmployeeEarningsSummary
WHERE EmployeeID = 2310
ORDER BY BonusAmount ASC

SELECT employeeID,
clientName,
clientCode,
MAX(CASE WHEN ADPBonusCode = 'BONUS' THEN ADPBonusCode END) AS ADPBonusCode1,
MAX(CASE WHEN ADPBonusCode = 'BONUS' THEN bonusAmount END) AS bonusAmount1, 
MAX(CASE WHEN ADPBonusCode = 'INCENTIVES' THEN ADPBonusCode END) AS ADPBonusCode2,
MAX(CASE WHEN ADPBonusCode = 'INCENTIVES' THEN bonusAmount END) AS bonusAmount2 
FROM Table
GROUP BY employeeID,
clientName,
clientCode
HAVING COUNT(DISTINCT ADPBonusCode) >1