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:267779 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
