Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is MAX() in GROUP BY reports wrong?
Message
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01521113
Message ID:
01521137
Views:
37
>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
Map
View

Click here to load this message in the networking platform