 SELECT  * FROM    (            SELECT  Year, Line, Total, mnt = DATENAME(month, DateAdd(month, [Month], 0)-0)           FROM    myTable         ) mt           PIVOT   (MAX(Total) FOR [mnt] IN ([January],[February],[March],[April],[May],[June],[July],[August],[September],[October],[November],[December])) AS PVT