Groups > comp.databases.ms-sqlserver > #702

SQL help again

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail
From	"Phil Hunt" <aaa@aaa.com>
Newsgroups	comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming
Subject	SQL help again
Date	Sun, 2 Oct 2011 12:14:11 -0400
Organization	Aioe.org NNTP Server
Lines	8
Message-ID	<j6a2kf$3d5$1@speranza.aioe.org> (permalink)
NNTP-Posting-Host	1F4WqZgmZBperfMg6Tnoqw.user.speranza.aioe.org
X-Complaints-To	abuse@aioe.org
X-MimeOLE	Produced By Microsoft MimeOLE V6.00.2900.6109
X-RFC2646	Format=Flowed; Original
X-Notice	Filtered by postfilter v. 0.8.2
X-Newsreader	Microsoft Outlook Express 6.00.2900.5931
X-Priority	3
X-MSMail-Priority	Normal
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:702

Cross-posted to 2 groups.

Show key headers only | View raw

How do I count a column that is NULL without CASE. I was looking at NULLIF 
and ISNULL, they can't seem to do the job.

Thanks

Sorry about double posting, I replied to my question by mistake.

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

SQL help again "Phil Hunt" <aaa@aaa.com> - 2011-10-02 12:14 -0400
  Re: SQL help again "Phil Hunt" <aaa@aaa.com> - 2011-10-02 12:48 -0400
    Re: SQL help again "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2011-10-02 13:06 -0400
      Re: SQL help again "phil hunt" <a@abc.com> - 2011-10-02 18:44 -0400
      Re: SQL help again "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-10-03 12:09 -0400
  Re: SQL help again --CELKO-- <jcelko212@earthlink.net> - 2011-10-03 08:55 -0700

csiph-web