SELECT tlp.PersonID, tlp.Program, ( SELECT COUNT(*) FROM dbo.tmmLicesnses2Persons tlp2 WHERE tlp2.Program = tlp.Program AND (DateActivated IS NOT NULL) AND (DateDeactivated IS NULL)) AS ProgramCount FROM dbo.tmmLicesnses2Persons tlp WHERE (DateActivated IS NOT NULL) AND (DateDeactivated IS NULL) GROUP BY PersonID, Program>>
>>SELECT PersonID, Program, COUNT(*) AS ProgramCount >>FROM dbo.tmmLicesnses2Persons >>WHERE (DateActivated IS NOT NULL) AND (DateDeactivated IS NULL) >>GROUP BY PersonID, Program >>>