title: tsql: How to retrieve the last date of each month between given date range
body: <p>I have two date for example 08/08/2013 and 11/11/2013 and I need last date of each month starting from August to November in a table so that i can iterate over the table to pick those dates individually.</p>
  
  <p>I know how to pick last date for any month but i am stucked with a date range.</p>
  
  <p>kindly help, it will be highly appreciated.</p>
  
  <p><strong>Note : I am using Sql 2008 and date rang could be 1 month , 2 month or 6 month or a year or max too..</strong></p>