hey trying to rename a header on the pivot,
The month is stored as int type, can i convert it to month name (jan, feb, march) across the top of the pivoted table instead of numbers?

how would i go about this? 

Example:
SELECT*

FROM Table1

PIVOT(

MAX(Score)

FOR[Month]IN([1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12]))

AS p
 
 Thanks!