SELECT     TOP (100) PERCENT dbo.tblBuilding.BuildingCode, dbo.tblBuilding.Description AS BldgDesc, dbo.tblRoom.Room, 
                      dbo.tblRoom.Description AS RoomDesc, COUNT(dbo.tblBooking.ID) AS Bookings, SUM(DATEDIFF(mi, dbo.tblBooking.TimeBookingStart, 
                      dbo.tblBooking.TimeBookingEnd) / 60) AS BookingHrs, SUM(DATEDIFF(mi, dbo.tblBooking.TimeEventStart, dbo.tblBooking.TimeEventEnd) / 60) 
                      AS EventHrs, dbo.tblRoom.RoomSize
FROM         dbo.tblBooking INNER JOIN
                      dbo.tblRoom ON dbo.tblBooking.RoomID = dbo.tblRoom.ID INNER JOIN
                      dbo.tblBuilding ON dbo.tblRoom.BuildingID = dbo.tblBuilding.ID INNER JOIN
                      dbo.tblStatus ON dbo.tblBooking.StatusID = dbo.tblStatus.ID
WHERE     (dbo.tblBooking.TimeBookingStart BETWEEN CONVERT(DATETIME, '2008-08-01 00:00:00', 102) AND CONVERT(DATETIME, '2009-08-01 00:00:00', 102)) 
                      AND (dbo.tblStatus.StatusTypeID = - 14)
GROUP BY dbo.tblBuilding.BuildingCode, dbo.tblBooking.RoomID, dbo.tblRoom.Room, dbo.tblRoom.RoomSize, dbo.tblBuilding.Description, 
                      dbo.tblRoom.Description
ORDER BY dbo.tblBuilding.BuildingCode, dbo.tblRoom.Room