I should have added this too:

Insert INTO #mytable

(Month_Year ,MyMonth,MyYear,ACC_Opened ,ACC_Opened ,ACC_Closed ,ACC_Backlog ,TimeStamp )

Select 'Apr-2014', '4', '2014','Investments','128','133','12', '2014-06-11 09:57:55.477'

UNion All

Select 'Aug-2013', '8', '2013','Investments','118','143','10', '2014-06-11 09:57:55.477'

UNion All

Select 'May-2014', '5', '2014','Investments','113','123','15', '2014-06-11 09:57:55.477'