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

right outer join

months as m on datename(month,dateadd(month,month(DepDate),-1))=datename(month,dateadd(mm,MonthNumber,0))