Hey all. Not sure if this was the right place to look. I'm building a room booking system and we're using SQL server (I know!!). I have a "reservations" table where I store the details of each reservation (date of booking, start/end timings, which room). I have a static list of rooms that are bookable. I'd like to show it on a schedule (a la iCal's weekly view). But I'm not sure how to do this as I'm not sure what records to "select" given that I won't have any records to signify which rooms are empty. Just which rooms are full at particular times, and I don't think I will be able to sort this table either. Thanks. Any and all help will be appreciated.