Posted by Ed Murphy on 09/19/07 23:19

Terry Olsen wrote:

> Yes, that works. But it doesn't show the row with no completes. So
> unless a person has at least one complete, they won't show.
>
> This will work for me, but is there a way to get it to include the
> people with no completes?

select Name, count(case Status when 'Complete' then 1 else 0 end)
from <<tablename>>
group by Name
order by Name

[Back to original message]