title: Sending query results via email via email attachment every first day of every month on SQL Server 2012
body: <p>My requirement:
  Send the query result via email attachment on first day of every month.</p>
  
  <p>The work I've been doing manually:</p>
  
  <ul>
  <li>I have to run this query every first day of each month by changing the date range.</li>
  <li>Then I export the result acquired in .csv format and send this csv file as an attachment</li>
  </ul>
  
  <p>I needed suggestions from you people on how shall I automate this process:</p>
  
  <ul>
  <li>Shall I set up a Job on SQL Server 2012, but yes, the I'll have to modify the date range.</li>
  </ul>
  
  <p>Please suggest on how to move forward.</p>
  
  <p>Any help, much appreciated. </p>