Use SSIS to build a package. Base a query on dateadd to get the previous 11 months in your query.