Ask a question. About essentially material optimization.
Don't know whether the SQL can do this. Or are there other more concise way to fast.

Thank you first.
The problem is shown in figure:
Attached picture:


Table a number of lines is uncertain. The length is the length of the order to use the. But the size of the raw material for the item is 3000 mm, and how to right watch? Note that this is not a simple SUM SUM and then divided by 3000 mm can. Because part of the size of less than 3000, is the LENGTH and the value is not greater than 3000

CodePudding user response:

https://bbs.csdn.net/topics/398539624

Feeling can consult # 5

CodePudding user response:

reference 1/f, kun jins kao kun jins kao response:

https://bbs.csdn.net/topics/398539624
Feeling can refer to the practice of the # 5

# 5 is pairing. But there is no return values only, he is the combination of multiple, did not consider the size of the unrepeatable.