Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is MAX() in GROUP BY reports wrong?
Message
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01521113
Message ID:
01521137
Vues:
38
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform