[thelist] SQL to get combo that sums to amount

aspscript at canada.com aspscript at canada.com
Wed Sep 8 22:20:44 CDT 2004

I have a table where each record has a field called
"quantity" with an integer value.  How would I
construct a query that searches thru hundreds of
records and determines what combination of those
records has a sum of the quantities that equals 50?

Any help or clues as to how to get started appreciated.

More information about the thelist mailing list