Yes, agree

We can achieve same with date part.

SELECT [Month] = DATENAME(mm,Created_Date), Sale

FROM

(

SELECT Created_Date = '2012-12-01', Sale = 10000

UNION

SELECT Created_Date = '2012-02-01', Sale = 1000

UNION

SELECT Created_Date = '2012-03-01', Sale = 2500

UNION

SELECT Created_Date...