select * from ( select year(pay_date) pay_date, month(pay_date) aa, sum(premium) sumPre from dbo.T_Bill_Pays where cntr_no = @cnr_no group by YEAR(pay_date), month(pay_date) ) a
PIVOT(--转换
sum(sumPre) FOR aa in ([1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12])
) b order by pay_date desc