Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using CASE within SUM()
Message
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01035999
Message ID:
01036038
Vues:
11
>>Del,
>>
>>You're missing comma after previous column and I would use BETWEEN operator for readability. I made corrections below in the code.
>
>Thanks for the catch. And I'm glad BETWEEN is also allowed here - I will use that as well.

T-SQL is more consistent than VFP in that respect. If you can use some operator in the WHERE clause, you can use it anywhere where such expression is allowed.
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform