General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2005
>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only