Peter do you have any idea why this isn't working or how I can make it work?
If you look at this query there is a ConsumedVol that sums everything that is 'consumed' and a ProducedVol that sums everything Produced.
I need to also do this for the ConsumedTotal and ProducedTotal. As the query is now I'm getting those numbers, but they are all lumped together. How can I do multiple sums in this query?
code: SELECT
ruhID,rudProductID,ruhDescrip,ruhDate,ruhLocationID,rudTotal AS ConsumedTotal,ConsumedVol=(SELECT SUM(ISNULL(rudVolume,0))
FROM
ProductionDetail
WHERE
rudID=ruhID
AND
rudCategory='Consumed'),rudTotal AS ProducedTotal,ProducedVol=(SELECT SUM(ISNULL(rudVolume,0))
FROM
ProductionDetail
WHERE
rudID=ruhID
AND
rudCategory='Produced')
FROM
ProductionHeader
LEFT JOIN
ProductionDetail
ON
ruhID = rudID
WHERE
ruhID
LIKE
'%bg%'
AND
ruhDate
BETWEEN
'5/1/11'
AND
'5/31/11'
GROUP BY
ruhID,ruhDescrip,ruhDate,ruhLocationID,rudTotal,rudProductID
ORDER BY
ruhDate DESC, ruhId ASC |
