title: MS SQL Server 2008 :Getting start date and end date of the week to next 8 weeks
body: <p>I am new to the SQL , can anyone give me query for this scenario ,"I need to display the startdate and  enddate of the week starting  from today's date to next 8 weeks " . For example if i select today's date , it should show </p>
  
  <ol>
  <li>Start Date  | End Date </li>
  <li>17/03/2012  | 23/03/2012</li>
  <li>24/03/2012  | 29/03/2012</li>
  <li>.. etc</li>
  <li>28/04/2012  |03/05/2013</li>
  </ol>