Is there a way.. for all the null values that appear due to no relationship, could that be canged to 0. I am already using a case statement, but still not changing them,
Is there a way.. for all the null values that appear due to no relationship, could that be canged to 0. I am already using a case statement, but still not changing them,
Regards
Rob
Can you show your case statement? Though you could use functions like ISNULL,COALESCE etc they all do CASE WHEN kind of check internally so even with CASE..WHEN it should work fine Just being curious on what went wrong in your case Anyways to avoid it you could use any of above functions
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Nulls on left join to 0
Posted - 02/19/2013 : 06:02:30
