Jim, Normally I would agree with you, but the problem is that the client wanted a simple editing / administration of this data as well.
And the other problem is that where do you draw the line on the final data? I really appreciate your help on this, the previous script I didn't even know was possible. Guess I still have a lot to learn about SQL:-) Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -----Original Message----- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Wednesday, 6 December 2006 2:00 PM To: SQL Subject: Re: Not sure how to do this Andrew Scott wrote: > Jim any idea how to add this to that script > > 1-3 days = $200 > 4-5 days = $350 > 6-6 days = $0 > 7+ days = $30 per day > > So 2 Days would be $200 and 6 days would be $350 > 10 days would be 4 * 30 + 350 > I'm still thinking that you need to get the data transformed into something a little more usable...so that in a case like above... 1 - 200 2 - 0 3 - 0 4 - 150 5 - 0 6 - 0 7 - 30 8 - 30 9 - 30 10 - 30 etc... Then your total is just a simple sum(). While I believe in keeping a lot of data processing on the db side of things, you really need to have the data presented in a way that supports that...otherwise the processing starts getting too complicated (as you are seeing). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2661 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
