title: SQL Query List of months between dates
body: <p>I've been searching without success for a way to list the months where my tables entries are in use.</p>
  
  <p>Let's say we have a table with items in use between two dates :</p>
  
  <pre><code>ID   StartDate   EndDate as ItemsInUse
  
  A   01.01.2013   31.03.2013
  B   01.02.2013   30.04.2013
  C   01.05.2013   31.05.2013
  </code></pre>
  
  <p>I need a way to query that table and return something like :</p>
  
  <pre><code>ID  Month
  A   01
  A   02
  A   03
  B   02
  B   03
  B   04
  C   05
  </code></pre>
  
  <p>I'm really stuck with this. Does anyone have any clues on doing this ?</p>
  
  <p>PS : European dates formats ;-)</p>