select * from(
select a.PROJECT_ID,a.REVENUE,a.FORECAST_MONTH
from FORECAST a
)p PIVOT (SUM(REVENUE) FOR FORECAST_MONTHIN([1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12]))C
posted on 2013-02-03 16:41 Amity 阅读(141) 评论(0) 编辑 收藏 举报