WITH months(MonthNumber) AS

(

SELECT 0

UNION ALL

SELECT MonthNumber+1 FROM months WHERE MonthNumber < 11

)

select datename(month,dateadd(mm,m.MonthNumber,0)),t.val from testing as t...