计算具有非零值的列数

SELECT COUNT(*) AS Total,
       ...
       ... 
       CASE ( WHEN SUM(CASE WHEN TypeId ='4' THEN 1 ELSE 0 END) > 0 THEN 1 ELSE 0 END) +  
       CASE ( WHEN SUM(CASE WHEN TypeId ='6' THEN 1 ELSE 0 END) > 0 THEN 1 ELSE 0 END) + 
       CASE ( WHEN SUM(CASE WHEN TypeId ='1' THEN 1 ELSE 0 END) > 0 THEN 1 ELSE 0 END) + 
       CASE ( WHEN SUM(CASE WHEN TypeId ='10' THEN 1 ELSE 0 END) > 0 THEN 1 ELSE 0 END) + 
       CASE ( WHEN SUM(CASE WHEN TypeId ='5' THEN 1 ELSE 0 END) > 0 THEN 1 ELSE 0 END) + 
       CASE ( WHEN SUM(CASE WHEN TypeId ='8' THEN 1 ELSE 0 END) > 0 THEN 1 ELSE 0 END)  
          as SumOfNonZeros

FROM [Party]

或者更简单

SELECT COUNT(*) AS Total,
       COUNT(CASE WHEN TypeId ='4'  THEN 1 END) AS 'TotalCount1', 
       COUNT(CASE WHEN TypeId ='6'  THEN 1 END) AS 'TotalCount2', 
       COUNT(CASE WHEN TypeId ='1'  THEN 1 END) AS 'TotalCount3', 
       COUNT(CASE WHEN TypeId ='10' THEN 1 END) AS 'TotalCount4', 
       COUNT(CASE WHEN TypeId ='5'  THEN 1 END) AS 'TotalCount5', 
       COUNT(CASE WHEN TypeId ='8'  THEN 1 END) AS 'TotalCount6',
       COUNT( DISTINCT CASE WHEN TypeId IN ('4', '6', '1', '10', '5', '8') 
                            THEN TypeId 
                       END ) as CountOfNonZeros
FROM [Party]