Ciao, prova in questo modo.
SELECT field,
countIstanceDailyIncome0,
countTotDailyIncome0,
countIstanceDailyIncome1,
countTotDailyIncome1,
countIstanceDailyIncome2,
countTotDailyIncome2
FROM (
SELECT 'countIstance' + name AS t, field, countIstance AS cnt FROM dbo.tbltemp
UNION
SELECT 'countTot' + name AS t, field, countTot AS cnt FROM dbo.tblTemp
) AS tbl
PIVOT
(
MAX(cnt) FOR t in
(countIstanceDailyIncome0,
countTotDailyIncome0,
countIstanceDailyIncome1,
countTotDailyIncome1,
countIstanceDailyIncome2,
countTotDailyIncome2
)
) AS pivottable