Count Nulls ?

[besto1a]

I have a basic Query:

SELECT CurrentStatus, COUNT(CurrentStatus) AS [Count of Status]
FROM dbo.tbl_EWTCases
GROUP BY CurrentStatus

THis works fine but will not produce a total for anything that is showing as Status null, how do i get this to count nulls ?

THanks

 

[gmmastros]

SELECT     CurrentStatus, COUNT([!]*[/!]) AS [Count of Status]
FROM         dbo.tbl_EWTCases
GROUP BY CurrentStatus

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLDenis]

change COUNT(CurrentStatus) to COUNT(*)

read this to understand more

http://sqlservercode.blogspot.com/2006/01/null-trouble-in-sql-server-land.html

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

 

[ptheriault]

This should include nulls

SELECT CurrentStatus,
COUNT(ISNULL(CurrentStatus,0)) AS [Count of Status]
FROM dbo.tbl_EWTCases
GROUP BY CurrentStatus

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[ptheriault]

But George and Denis are correct.
COUNT(*) gets everything.


- Paul
- If at first you don't succeed, find out if the loser gets anything.