-- another method, this time with datediff. (don't think it was covered before....apologies if it was.)

SELECT Created_Date, 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 = '2012-04-01', Sale = 12000

UNION

SELECT Created_Date = '2012-05-01', Sale = 5500

UNION

SELECT Created_Date = '2012-06-01', Sale = 6500

UNION

SELECT Created_Date = '2012-07-01', Sale = 7500

UNION

SELECT Created_Date = '2012-08-01', Sale = 20000

UNION

SELECT Created_Date = '2015-09-01', Sale = 1500

UNION

SELECT Created_Date = '2012-10-01', Sale = 15000

UNION

SELECT Created_Date = '2012-11-01', Sale = 4000

UNION

SELECT Created_Date = '2012-01-01', Sale = 50000

) T1

ORDER BY DATEDIFF(m,0,Created_Date) % 12