XPost: microsoft.public.sqlserver.programming   
   From: a@abc.com   
      
    That's it.Thanks.   
      
      
   "Bob Barrows"  wrote in message   
   news:j6a5n5$9d3$1@dont-email.me...   
   > Phil Hunt wrote:   
   >> I tried   
   >> CASE EventID when NULL then 1 else 0 end   
   >>   
   >> It always return 0, why ?   
   >>   
   >>   
   > Because the way you have the statement structured is causing an equality   
   > comparison to be performed, the result of which will always be false. You   
   > have to structure it like:   
   >   
   > CASE when  EventID IS NULL then 1 else 0 end   
   >   
   > To answer your original question, you can subtract the result of   
   > count(distinct column_name) from count(*):   
   >   
   > select count(*) - count(distinct eventid) as null_eventids   
   >   
   >   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)