Statistical Combination in SQL

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Teradata Employee

Re: Statistical Combination in SQL

Very impressive @dnoeth as usual.

 

I had an almost same beginning of your expand solution but I didn't find a formula to compute the PossibleGroup column.

And it should scale much better than the recursive query !