I have a query that gets a ton of data, then I re-use it over and over
to create a very specific 1-record per column formatted report. Well,
the problem I have is that some types of record don't exist in a given
column. In this QoQ:
SELECT
SUM(GrossPay) as Amount,
0 as totalMiles,
payYear,
payMonth
FROM
getData
WHERE
payClass = 'HOLI'
GROUP BY
payYear,
payMonth
ORDER BY
payYear DESC,
payMonth DESC
How can I force a record for a given year and month, and give it a value
of zero? Otherwise I will have to start coding funky looping glory, and
I want to avoid that! Since QoQ cannot do a sub-query (that I know of) I
am stuck, help!
Chris Peterson
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267777
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
