Interesting, thanks for the tip; I'll have to watch out for that. So it seems to result in a sum(distinct value) instead of sum(value), right?

It does seem like pre-aggregating the data is the key, but I wouldn't use a temp table and an update, I'd just use a derived table or view, then aggregate the results as well:

select salesPersonsName

, sum([Jan]) as [Jan]

, sum([Feb]) as [Feb]

, sum(SaverPoints) as SaverPoints

from

( select

salesPersonsName

, sum(numberOfSales) as NumberOfSales

, monthAbv

, sum(saverPoints) as saverPoints

from #tmpPivotTest

group by

salesPersonsName

, numberOfSales

, monthAbv

) as SourceTable

PIVOT (sum(numberOfSales) for monthAbv in ([Jan],[Feb]) )as PivotTable

group by salesPersonsName