You're a miracle-worker! Thank you very, very much!


>Hi!
>
>Try following:
>
>Select Sys, COUNT(CASE WHEN Status=1 THEN 1 ELSE 0 END) as successful,
>COUNT(CASE WHEN Status=2 THEN 1 ELSE 0 END) as failed,
>COUNT(CASE WHEN Status=3 THEN 1 ELSE 0 END) as invalid,
>COUNT(CASE WHEN Status=0 THEN 1 ELSE 0 END) as pending
>FROM MyTable GROUP BY Sys
>