[dba-SQLServer] Null and DISTINCT

jwcolby jwcolby at colbyconsulting.com
Fri Sep 18 12:52:00 CDT 2009

Previous message: [dba-SQLServer] Table Link Refresh Required After Table
Next message: [dba-SQLServer] SPAM-LOW: Null and DISTINCT
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

I have a result set where I have a ton of records that are absolutely identical.  I am trying to do 
a DISTINCT but there is one field that is pulling a NULL.  Is it true that the NULL will prevent the 
DISTINCT from working in this case?

Any way around this?
-- 
John W. Colby
www.ColbyConsulting.com

Previous message: [dba-SQLServer] Table Link Refresh Required After Table
Next message: [dba-SQLServer] SPAM-LOW: Null and DISTINCT
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

More information about the dba-SQLServer mailing list