I am developing a scheduling application and am having issues with outputting of a sparse table. On the Y axis (column) are locations (rather rooms to be scheduled) and on the X axis (row) are times (whole times, eg 8:30am, 9:00am, 9:30am etc). Meetings can run for a half hour or 2, 3 hours etc. Simply put, I need to output a row for each location and in certain columns 'block out' that time. Open times should have a cell populated with a link to our scheduling form. A static example of how the table should like (minus the fact that every cell is filled in) can be seen here: http://cfdev.ucsd.edu:81/beta/loop.cfm
I am trying to avoid running logic on each cell to determine if its open or not. That and running multiple nested loops. Response time is a large priority.
What I have seen thus far: structs being used to speed up the data interaction as well as stored procedures (I am using MS SQL Server).
Any ideas guys? Its got me and a few others in the office stumped!