So, what I am trying to do is:

;WITH SampleData

([Customer ID], Var1, Var2, Var3, Var4, Var5, Var6, Var7, Var8, Var9, Var10, Var11, Var12, Var13, Var14, Var15, [Outcome Label])

AS (

SELECT '123',3,0,5,0.5,0.885889264,0.6,0.023603498,0,1,0.89,1,0.654,0,6,1,1

UNION ALL...

Hi,

This is great but the problem is that I have my data in variables (columns) and need it outputted in variables back, so that I can use them to filter...

Hi,

This is great but the problem is that I have my data in variables (columns) and need it outputted in variables back, so that I can use them to filter...

A,B,C,D,Outcome

A1,B1,C1,D1,1

A2,B2,C2,,0

A3,,C3,,1

A4,,C4,,1

,,C5,,0

The code ran for about a day on my 3 TB partition and I got an error. My dataset is really small but the combinations increase the size. This is...

Ok.

What I am trying to do is to filter a dataset on all possible combinations.

My code does create combinations in a separate dataset but I am unable to completely run...