Viewing 3 posts - 1 through 3 (of 3 total)
When doing a comparison that have null values, the best way is to convert it. Keeping the null values in aggration will always cause issues.
select a.id, a.desc1, b.desc1
from #tempa...
July 21, 2009 at 10:22 am
This is documented in BOL for null values;
"Null values cannot be used for information that is required to distinguish one row in a table from another row in a table"
Based...
December 5, 2005 at 11:56 am
When we specify the column names, the sql will not count the null values even if the ansi_null off
select count(*) from #temp = 1
select count(a) from #tmp = 0
December 2, 2005 at 12:44 pm
Viewing 3 posts - 1 through 3 (of 3 total)