oh, ok. Sorry I should have mentioned it. There will be where caluse , SO that the query only picks current one year data.
So there will always be 12 months data in resultset.
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.