Yes it does, that was the initial filter for dates that i used, but seemed not to work for some cases (actors, rooms).

consider a booking from Monday to Friday from...

That is right, i don't have too much power over the client's ideas, but after all it's a feature of the application.

I tried to do the sum of BookedNo with...

This is the main definitions used in this case scenario, the tables contain more columns, but these are the columns specific to this situation

tblBooking :

id int

resourceId int, -- related...

so is there any way to achieve this faster?

consider a table with 10.000 records with BookingStartDate, BookingEndDate, RoomId and Id

A simple test for all Booking Id to tell whether...