DECLARE @i INT  
SET @i = 0  
WHILE (@i < 15)  
BEGIN  
SET @i = @i + 1  
EXEC ('CREATE TABLE VAR' + @i + '(VAR' + @i + ' VARCHAR(50))')   
END  

INSERT INTO VAR1 (VAR1) SELECT DISTINCT VAR1 FROM [Training Data]  
DECLARE @i INT  
SET @i = 0  
WHILE (@i < 15)  
BEGIN  
SET @i = @i + 1  
EXEC('INSERT INTO VAR' + @i + ' (VAR' + @i + ')' + ' SELECT DISTINCT VAR' + @i + ' FROM [Training Data]')  
END  

CREATE TABLE ALL_COMB (VAR1 VARCHAR(50), VAR2 VARCHAR(50), VAR3 VARCHAR(50), VAR4 VARCHAR(50), VAR5 VARCHAR(50), VAR6 VARCHAR(50), VAR7 VARCHAR(50), VAR8 VARCHAR(50), VAR9 VARCHAR(50), VAR10 VARCHAR(50), VAR11 VARCHAR(50), VAR12 VARCHAR(50), VAR13 VARCHAR(50), VAR14 VARCHAR(50), VAR15 VARCHAR(50))  
INSERT INTO ALL_COMB (VAR1, VAR2, VAR3, VAR4, VAR5, VAR6, VAR7, VAR8, VAR9, VAR10, VAR11, VAR12, VAR13, VAR14, VAR15) SELECT * FROM VAR1, VAR2, VAR3, VAR4, VAR5, VAR6, VAR7, VAR8, VAR9, VAR10, VAR11, VAR12, VAR13, VAR14, VAR15  
ORDER BY VAR1, VAR2, VAR3, VAR4, VAR5, VAR6, VAR7, VAR8, VAR9, VAR10, VAR11, VAR12, VAR13, VAR14, VAR15;  

select sum(Outcome)/count(Outcome) as Perc, count(Outcome) as Lines from Sample_Data where var1 = 1