thanks for the kudos.

Yes, I agree, it grows exponentially as the number of rows increases. I would prefer a more elegant solution but for now this solution meets my...

Thanks greatly to COldCoffee's post, which was way over my head of course, but I was able to pluck out the pieces that worked for me, specifically the bitwise pieces....

Wow - thanks. One issue I found was dbo.Numbers does not exist. Can you please provide that too. Thanks

Here's something that I came up with that kinda works, it has one flaw where if it finds a match with 1,7,8, it will also find a match with 1,8,7...

Ok - here is the business requirement. A customer sends a check to pay a bill or combination of bills. I want to determine which bills they meant...

I guess I'm unclear on what you mean by running total. If rows 2 and 7 add up to the value in the @amount variable, I want those ID's...

I tried that solution and it seems close, but it only works for two contiguous rows. And doesn't support if 3 or more rows are what comprise the result.

Hey,

No, I'm looking for the combination of ID's whose corresponding amounts sum up to the value in the @amount variable. This could be just one row if it's a...

I appreciate your response but that solution doesn't actually return the combinations because it groups by the ID.

Thanks for the quick response, and yes, the solution could be 1-n.

I appreciate your quick response and offer of assistance, but I thought about doing that but the solution seems like it would be slow to get all the different combinations...