>Hi Naomi,
>
>The query executes fine but does not return the result I am looking for.
>
>The problem is with grouping by EDP. The result return nPVC and nSVC values based on the max(date) but if the max record includes either nPVC or nSVC = 0 than I need the last none 0 value.
>
>Results of your query:
>EDP SVC PVC
>23733 12.12 0.00
>25555 100.12 111.12
>
>Should be
>EDP SVC PVC
>23733 12.12 15.12
>25555 100.12 111.12
>
>I ended up using cursor and processing one record at the time. This is probably the least efficient way of acomplishing this task but at least it does work.
>
>Thank you,
>daniel
Hi Daniel,
I just quickly reviewed my query and I think all you needed to do to make it work is to remove UNION ALL part. But this is from the quick glance, need to think a bit more.
If it's not broken, fix it until it is.
My Blog