XPost: microsoft.public.sqlserver.programming   
   From: reb01501@NOyahooSPAM.com   
      
   Bob Barrows wrote:   
   > 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   
      
   Oh dear. Why did I put that "distinct" in there? I have no idea what I was   
   thinking when I typed that. The correct statement is as CELKO wrote:   
   select count(*) - count(eventid) as null_eventids   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)