distinct count not distincting... 1

[pbateman]

Anybody got any clues as to why:

select distinct count (a.serv_dept_id) as Number_of_Teams, a.incident_id
from
act_reg a
group by
a.incident_id

is ignoring the 'distinct' bit and behaving as a normal 'count'?

Am reporting against an sql server db and using crystal 10 (not that either of those things should make a difference with something so simple).

 

[MisterMo]

try

select count (distinct a.serv_dept_id) as Number_of_Teams, a.incident_id
from
act_reg a
group by
a.incident_id


Mo

 

[pbateman]

Thank you. The one variation I didn't try, and would never have thought of....