Andrew,
Can you send the query you currenlty are using?
Rodney
-----Original Message-----
From: Andrew Scott [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 02, 2007 10:33 PM
To: SQL
Subject: Need help with a sql query
I am trying to fix a bug that I can see, just not sure how to get it to
work correctly.
I have 2 tables joined one holds information regarding a room, and the
second holds seasonality dates.
So if I have the following to run a query on:
Start Date: 31-Oct-2007
End Date: 10-Nov-2007
The seasonality table has 2 rows
Season1 Start: 1-Oct-2007
Season1 End:31-Oct-2007
Price1: $100.00
Season2 Start: 1-Nov-2007
Season2 End:31-Dec-2007
Price2:$200.00
Now the current query returns 2 records one with number of days @ $100
and number of days @ $200, the client is needing that these get totalled
so that if there is 1 @ $100 and 9 @ $200 then it becomes a total of
$1900.
Does this makes sense? It is driving me insane let me tell youJ
Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
<http://www.aegeon.com.au> www.aegeon.com.au
Phone: +613 8676 4223
Mobile: 0404 998 273
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion is delivering applications solutions at at top companies
around the world in government. Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2964
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
