行转列-

   		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