pivot列行转换，自动计算分组，解决groupby问题

select top 20 * from
(
select PromotionRateAmount,(cast(year(ReserveDate) as varchar(4))+cast(month(ReserveDate) as varchar(2))) as MonthSum,OrderId select PromotionRateAmo