• Try this bick, and please reply with the results... I am not on a machine with management studio, so can't test.

    SELECT datakey,COUNT(datakey) OVER(Partition by datakey) AS Uniquedatakey,

    COUNT(landline) OVER(Partition by datakey) AS Uniquelandline,

    COUNT(mobile) OVER(Partition by datakey) AS Uniquemobile,

    COUNT(emailD)OVER(Partition by datakey) AS Uniqueemail

    FROM test

    group by datakey