Well, my platform is DB2, and while I have done some simple SP's in the past, I don't know how to structure this. My other problem is that, using my same original query data set, I need to output all detail records on a separate file. I try to minimize hitting the database the best I can, so if I can do a trick to fit in with my QoQ setup I would rather!
Chris -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Friday, January 26, 2007 3:41 PM To: CF-Talk Subject: Re: QoQ question - anyone know any tricks? SP an option? "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Peterson, Chris To: CF-Talk Sent: Fri Jan 26 20:43:29 2007 Subject: QoQ question - anyone know any tricks? 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:267781 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
