I need help with a query.
Lets say I have a table with this data :
So those are boxes.. box A1 has a place of 5 units. A2 7 units and so on.
So, what I want is... a query that if I send a parameter of lets say the number 115
I would like that for 115 units... it returns me the results of 2 box A5 ( 55 + 55 = 110) and another row with box A1
do you see where im getting...
if it was 116
it would be 2 box A5 and 1 box A2 ...
I need this in sQL ....
thanks EE ....