title: How to Split Sql Int Value into Multiple Rows
body: <p>Lets say I have the following table in MS SQL 2000</p>
  
  <pre><code>Id | description | quantity |
  -------------------------------
  1    my desc          3
  2    desc 2           2
  </code></pre>
  
  <p>I need to display multiple rows based on the quantity, so I need the following output:</p>
  
  <pre><code>Id | description | quantity |
  -----------------------------
  1    my desc          1
  1    my desc          1
  1    my desc          1
  2    desc 2           1
  2    desc 2           1
  </code></pre>
  
  <p>Any ideas how to accomplish this?</p>