title: Split date range into one row per month in sql server
body: <p>I have a table with two column called "from_date" and "to_date"</p>
  
  <pre><code>    the table look like:-
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/Zg62g.png" alt="enter image description here"></p>
  
  <p>I want result like:-</p>
  
  <pre><code>from_date            to_date   
  -----------         ------------  
  2013-11-25           2013-11-30
  2013-12-01           2013-12-05
  </code></pre>
  
  <p>That date is splits from 2013-11-25 to 2013-11-30 and another date split from 2013-12-01 to 2013-12-05... Is it possible to split like this ?</p>