jwcolby
jwcolby at colbyconsulting.com
Thu Jul 26 08:54:01 CDT 2012
I have two queries:
SELECT [EM_Email]
,[EM_EmailDomain]
FROM [_DataEmail].[dbo].[tblEmail_Live]
WHERE EM_EmailDomain is null
GO
Returns nothing.
SELECT TOP (100) PERCENT COUNT(PK) AS Cnt, EM_EmailDomain
FROM dbo.tblEmail_Live
GROUP BY EM_EmailDomain
ORDER BY Cnt DESC
returns null as the top most common EM_EmailDomain
Same table, same field, one query says I have lots of null values by count, the other query refuses
to show them to me.
I'm confused.
--
John W. Colby
Colby Consulting
Reality is what refuses to go away
when you do not believe in it