title: SQL - Insert rows based on count
body: <p>I'm looking to insert a number of repeating rows into a table, based upon the value set by another - ideas &amp; suggestions would be greatly appreciated.</p>
  
  <pre><code>tblType
  Type     Qty
  Apple    2
  Banana   1
  Mango    3
  
  tblResult
  Apple
  Apple
  Banana
  Mango
  Mango
  Mango
  </code></pre>