• I can't quite match your requested results, can you double check them?

    I make it: -

    Total Total Unqiue Datakey Total Unique Landline Total Unique Mobile Total Unique Emai

    -------------------- -------------------- --------------------- ------------------- -----------------

    9 6 6 4 3


    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/