Stuck on creating a recordset for displaying free/busy time for a meeting calendar i'm working on
Using: MS SQL 2000
this particular problem involves 4 tables
locations (locationid int, locationname varchar)
meetings (meetingid int, meetingname varchar, meetingdate datetime, )
meetingitems (itemid int, itemstarttime varchar, itemfinishtime varchar, locationid int, itemtypeid in, meetingid int)
itemtypes (itemtypeid int, itemtype varchar, notes char)
The tables Locations and Itemtypes are both really just lookup tables
The table Meetings contains information specific to the meeting
The table MeetingItems contains agenda items and start and finish times of each item which belongs to a meeting.
One meeting can have multiple agenda items.
The problem I am have is returning a recordset to return in my Coldfusion page to show a room availability (free/busy) chart, so at a glance a meeting organiser can see which rooms are available for a certain timeframe... will default to just one day.. from 8am to 8pm in 30 minute increments.
There is a total of 7 rooms
If you take a look at this link:
You'll see what I mean - except in this example the meeting room name replaces the participants name.
Would be appreicated in a stored procedure whereby I can pass a date range and an optional locationid, so I can say show me roomX's availability for the next day or week etc.