Hi ,
I have a requirement as below and please advise me on this.
Person Name XYZ
Hotel Check In Date 01/Aug/2013
Hotel Check Out Date 05/Aug/2013
When I search by giving date as 03/Aug/2013 in this particular hotel, I should see person XYZ is already a inhouse guest.
Inserting rows from 01 to 04 as Check In Date would work and if this is ok, how to handle this.
So I guess something like above or what you have mentioned would work but my confusion is that how to handle between two dates and it is not a series.
thanks,
Senarath
