Ninja's_RGR'us (4/7/2010)
Lynn Pettis (4/7/2010)
It may help to see the whole problem not just a piece of it. Can you put together a test suite including the expected output? I know I work better when I know the whole problem, and can see what the end result should be.That post would contain about 500 lines of code and another 2000 to build the relevant objects and test data which I'm sure I can't provide because it contains personal data. And of course there's even more to it than what I said but those missing pieces are basic joins to other tables, nothing relevant to my little problem.
I have everything working except the piece to build all possible combinaisons which is where I need help. Other than just going with a loop I don't see any easy way out of this one.
Not asking for actual data, but sample data; something that at least represents the problem domain. From what you have posted I'll have to leave it to others who are more imaginative. I need to see the problem and what the ultimate result is going to be to be of any help.