title: how to get automatically previous month date range in SQL?
body: <p>I have  2012 SQL Server stored procedure ran automatically every fifth of the month but the problem I have is supplying previous month date range e.g. I need to have clause like  <strong>...where  datein  between '2014-02-01' and '2014-02-28'</strong> and next month it would change it to <strong>...where  datein  between '2014-03-01' and '2014-02-31'</strong> and so on.  </p>
  
  <p>thanks</p>