title: Multiply rows in single query
body: <p><strong>Table1</strong> has the following 2 columns and 4 rows:</p>
  
  <pre><code>Entity Number
  ------ ------
  Car    4
  Shop   1
  Apple  3
  Pear   1
  </code></pre>
  
  <p>I'd like to have one set based SQL query, which produces the below desired results. Basically duplicating the Entities by the Number of times in the Number column.</p>
  
  <p>I could only do it by loop through the rows one by one, which is not really elegant, neither set based.</p>
  
  <p>Desired result:</p>
  
  <pre><code>Entity
  ------
  Car   
  Car   
  Car   
  Car   
  Shop  
  Apple 
  Apple 
  Apple 
  Pear  
  </code></pre>