DoubleBooking issue with RnR

Hi All,

I have a double booking issue with my RnR system, Scenario is like

Im using @FindFreeResource to get available rooms list provided the time and location of the reservation, when user attempt to select the listed rooms and say reserve its prompting like"Selected room has already been booked…"

I beleive this @FindFreeResource function returns only resource that are not booked in the specified time In that case already booked room shud not at all be listed in my search result…

so wats wrong with my @FindFreeResource y is it listing already booked reources!?

Any idea to reolve this issue with my RnR

Thanks in advance