How Can I automate query result and send email in excel sheet which will be running every monday with out using ssis and ssrs?

stephen_hendricks · November 29, 2016, 6:38pm

As far as the scheduling goes, you could put your code in a SQL Agent Job and set it to run weekly on Monday. How to put the query into Excel is a different story. How you considered using an Excel driver and "insert"ing the data? You could find the driver with a Google search.