>>>Hi Agnes,
>>>
>>>I'm not sure why do you expect any query to fix your bad data. The fact that you don't know exactly what result you want doesn't help either.
>>
>>Oh no. Not my bad data. I'm not responsible. The way it works is customers explicit wish and responsibility.
>>
>>Agnes
>
>Lets try again, :)
>
>I'm not sure why do you expect any query to fix your clients bad data.

Hi Sergey,

because the clients pays it. I do a lot with assumptions on bad data. As long as the client knows how the read the stuff anything is fine. The changed logic on group by makes only harder. (Two more lines where I need it. <g>)

Agnes