SQLite Forum

Repeat values n times
Login
Dear Gunter Hick,

I needed the identical values repeated for n number of times for the output values to be printed exactly for n numbers.

Let me clarify further.

I have a list of skus (items) and the qty in one table (received sales orders). Now based on qty I want to print that many labels of each sku. This list serves as a source table (in mail merge) for the printouts. Now I have to pass print command for a particular sku and select copies as per qty to make that many copies of the labels. So I chose to change the source table to be containing exactly that number of skus which I want to print, note that skus will be repeated based on their qty. In this way I don't have to select the copies for each sku separately. I can directly give print command without thinking of each sku. So I put all this into sqlite script, run it, populate the target table with all skus. 

This is kind of automation to save time and increase the work flow.