I have a registration web site running ASP.NET 2.0 with SQL Server 2005 Express DB. Some of the details that are collected during the registration process are accommodation details.
The fields in the Users table of the DB associated with this are "CheckInDate"(type DateTime), "CheckOutDate"(type DateTime) and "RoomTypeID"(Integer). I have had a request to produce a roominglist that will plot how many of the room-types are booked for each date/night of the event.
I am a bit stumped on the best way to approach constructing the procedure to obtain this report.
Any help gratefully recieved!