Is there a way to dynamically create an INSERT Statement? I have the following issue:
When a customer orders a product and they order 10 of the same product. Each product has a unique product ID and and unique information. Each of the products ordered needs to be inserted on its own. So if someone ordered 10 items I would need to have 10 insert statements.
Is there anyway to write the insert statement so it loops and inserts however many times the quantity is set to?
So if a customer ordered 37 items, the insert statement would automatically loop 37 times.