title: sql how to split a row into multiple rows
body: <p>We have a table and I want to split a row in that table into multiple rows. 
  If you see below. That is one row from my table. We are calculating resource loading and I want to split this row below into the result table also shown in the image below.</p>
  
  <p>I will take care of calculating the week start date and hours, just tell me how can I split a row into multiple rows in sql server 2005.</p>
  
  <p><a href="https://i.stack.imgur.com/4BrXQ.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4BrXQ.jpg" alt="MyImage"></a></p>
  
  <p>Here in this example David worked from march 3rd to march 19 for 25 hours.</p>
  
  <p>Which means if we divide this by number of weeks worked, comes to 2 weeks.</p>
  
  <p>From week starting march 7 to week ending march 11, and then week starting march 14th to week end march 18th. </p>
  
  <p>The hours are split based on number of weeks worked in ratio of number of days worked.</p>