Chris Morris-439714 (12/3/2010)
What folks often forget about tally tables is that they are a source of rows as well as numbers.
I've actually used a Tally Table to do that too, but a conditional needs to be put on the join to keep it from oversizing the rows.
But does Quantity reflect a single unit or the 4 Qty that the OP was talking about? That's why I asked for DDL (should have also mentioned sample data), because doing it wrong can screw up inventory.