Hi need help with some SQL, I need to split some data in my informix database, is there a way to take the quantity and work out how many boxes are required and return the correct amount of rows? I require it like this so I can print the correct number of labels.

Current
Code:
PART                 QUANTITY              PARTS PER BOX
AB123                2400                     480
CD346                550                      100

Need it to return this.

Code:
PART                 QUANTITY              PARTS PER BOX
AB123                480                       480
AB123                480                       480
AB123                480                       480
AB123                480                       480
AB123                480                       480
CD346                100                      100
CD346                100                      100
CD346                100                      100
CD346                100                      100
CD346                100                      100
CD346                50                       100
Really appreciate any help.