>>>>Hi,
>>>>
>>>>Several of my reports use MAX(CHAR_FIELD) AS CHAR_FIELD when using GROUP BY clause. This, of course, to make sure that the GROUP BY does not "break" the report. My question is, is it wrong to have many MAX() for this purpose? Should I change the reports such as to minimize using MAX() around char type fields?
>>>>
>>>
>>>A purist might say it's wrong. In practice the character field probably has the same value for all items in the group. I have done this myself without lying awake nights worrying about it.
>>
>>With Naomi's help I think I found a way to get rid of these MAX() all together. I am working on this now.
>
>Take the rest of the day off, Dmitry ;-)
>
>Actually I liked what you said the other day about the people who are willing to work harder being entitled to greater rewards. That probably wasn't exactly the way you said but I think it was the gist of it.
Thank you. Good night, Mike.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
