Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 6.5 and older
>Very quick one....there are several ways....one way (probably not the best for performance, but...)
>
>SUM ( case when Category = 'Capacity' then Total_Cost else 0 end) as Whatever
>
>
>
>Again, not great for performance, but I believe it should work.
>
>Alternatively, if that doesn't work, you could do a subquery with the total just for that category, and then join to the subcategory results.
>
>But let me know if that works...
Thanks Kevin !!
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement