Hello DB gurus, I need your help.
I am working on a receiving report where I need to print multiple QR codes of each item. Example:
Receiving Report: 00001 Items Quantity --------- ------------- Item A 15 Item B 10 Item C 25
I am using MySQL db and the above sample is stored in a table called RRDetails. Of course, the structure is just an abstract.
Although I only have 3 items, I need to print 50 qr codes ( 15 for Item A, 10 for Item B and 25 for Item C). I was told that in order to accomplish this, I have to write a stored procedure in mysql, that stored proc would create a temporary table and then be populated from the number of quantities of the filtered rows from RRDetails.
Anyone can lead me to the solution?
Thank you all!