Gnub Posted March 27, 2007 Share Posted March 27, 2007 At the moment, i have a table with a list of hotels, with 2 fields, AvailableFrom, AvailableTo. Example: Hotel: AvailableFrom: Available To: Hotel1 01/01/2007 03/03/2007 Hotel2 02/02/2007 05/05/2007 Is there a function, where i can create a temporary table, where it will hold Hotel data but instead of having AvailableFrom and AvailableTo, to hold the dates between AvailableFrom and AvailableTo. So it would then hold: Hotel: Date: Hotel1 01/01/2007 Hotel1 02/01/2007 ... Hotel1 03/03/2007 Would appreciate any help you can give, how do i accomplish such a task? Quote Link to comment Share on other sites More sharing options...
effigy Posted March 27, 2007 Share Posted March 27, 2007 Why not use BETWEEN? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.