asked on
Hello, I need to build a store procedure that sums the results of a query. I need to make a sum of "SubTotal" and return it. How can I do this?
Thanks.
Thanks.
SELECT
assignment.TskCod,
task.TskHHP,
IF(AssType = 'install', task.TskHHP * task.TskI_Percentage, task.TskHHP * task.TskR_Percentage) AS SubTotal
FROM
assignment
INNER JOIN task ON (assignment.TskCod = task.TskCod)
WHERE
AssDate >= '2011-01-01' AND
AssDate <= '2011-01-31'
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.