;with cte as ( select 0 'F' union select 1 ) select * from cte c1, cte c2,cte c3, cte c4, cte c5, cte c6, cte c7,cte c8, cte c9 where c1.F + c2.F + c3.F + c4.F +c5.F + c6.F +c7.F +c8.F + c9.F = 5