1–10…51–6061–7071–75

Some CFML Stuffs Me Do

From: Peter (BOUGHTONP) 2 Jun 2011 16:41
To: Ken (SHIELDSIT) 71 of 75
38447.71 In reply to 38447.70
I've no idea if it'll run against Railo or not - wouldn't be surprised if Adobe had deliberately made it incompatible in some way. :/
Reply
0/0
From: Drew (X3N0PH0N) 3 Jun 2011 02:15
To: Peter (BOUGHTONP) 72 of 75
38447.72 In reply to 38447.67
Reply
0/0
From: Ken (SHIELDSIT) 3 Jun 2011 03:03
To: Drew (X3N0PH0N) 73 of 75
38447.73 In reply to 38447.72
haha, I guess there's a comic for every situation!
Reply
0/0
From: Peter (BOUGHTONP) 3 Jun 2011 07:58
To: Drew (X3N0PH0N) 74 of 75
38447.74 In reply to 38447.72
I don't chew gum.
Reply
0/0
From: Ken (SHIELDSIT) 3 Jun 2011 17:33
To: Peter (BOUGHTONP) 75 of 75
38447.75 In reply to 38447.74
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
Reply
0/0