PIVOT

SELECT tempcodedesc AS '項目',SMT01 AS '1月SMT',AP01 AS '1月AP',SUM01 AS '1月Total',SMT02 AS '2月SMT',AP02 AS '2月AP',SUM02 AS '2月Total',SMT03 AS '3月SMT',AP03 AS '3月AP',SUM03 AS '3月Total',SMT04 AS '4月SMT',AP04 AS '4月AP',SUM04 AS '4月Total',SMT05 AS '5月SMT',AP05 AS '5月AP',SUM05 AS '5月Total',SMT06 AS '6月SMT',AP06 AS '6月AP',SUM06 AS '6月Total'
     INTO #temp_groupaNO11
     FROM #temp_groupaNO
  PIVOT (SUM (tempexpense) FOR tempprocess IN (SMT01, SMT02, SMT03, SMT04,SMT05,SMT06,AP01,AP02,AP03,AP04,AP05,AP06，SUM01,SUM02,SUM03,SUM04,SUM05,SUM06) ) AS P ORDER BY tempcodeno,tempcodedesc DESC