|
From: Pink E. <in...@ba...> - 2011-08-01 05:23:09
|
Good morning,
>You haven't said specifically what the expected results should be for a
>given condition.
Yes, you right. I am blond, I am sorry. :-)
Further, although the database will be appreciated, should it be needed, you
need to provide specific details to reproduce, the current details are not
enough for that purpose.
I`ll prepare today and send you link
It seems that you believe that if a REM.{field} is NULL that the results
should have a non-NULL value, you are mistaken. SQL defines very specific
rules for the handling of NULLs.
No. Problem in calculation while field has null and non null values. If all
values are null result will Ok. if all values are not null result will ok.
If values mixed and case is presented and Sum is present result is not ok in
sum
Dmytro Lendel
Pink Elephant
(+38) 0312 612136
www.bagel.com.ua
www.pidkova.biz
|