Home Forums Reporting Services Reporting Services SSRS - Count of Distinct People Where Gender = RE: SSRS - Count of Distinct People Where Gender =

  • December 16, 2010 at 10:27 am

    #1263570

    is that's what you want?

    SELECT

    count (*)

    FROM

    (SELECT DISTINCT

    PERSONID,

    GENDER

    FROM DATASET)