RE: Help with Counts – SQLServerCentral

One Orange Chip

Points: 26944

January 11, 2012 at 9:09 am

Is this what you're after?

SELECT COUNT(*) AS Total,

COUNT(DISTINCT datakey) AS Uniquedatakey,

COUNT(DISTINCT CASE WHEN landline<>'' THEN landline END) AS Uniquelandline,

COUNT(DISTINCT CASE WHEN mobile<>'' THEN mobile END) AS Uniquemobile,

COUNT(DISTINCT CASE WHEN email<>'' THEN email END) AS Uniqueemail

FROM test

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum