|
Thanks for all your help on this, but I think I made the problem more
complicated than it is:
What I want to see is for every interval (whether or not use starts on
that interval) how many resources are occupied for that interval.
from this
resource start end
16 3/3/01 5:30 PM 3/3/01 8:30 PM
4 3/3/01 7:00 PM 3/3/01 11:00 PM
14 3/3/01 7:30 PM 3/3/01 11:30 PM
to this
timeslice resources in use
3/3/01 6:00 PM 1
3/3/01 6:30 PM 1
3/3/01 7:00 PM 2
3/3/01 7:30 PM 3
3/3/01 8:00 PM 3
3/3/01 8:30 PM 2
I think I will need to create a set of bins for every half hour (or
whatever interval) and then evaluate each reservation against it, a la:
IF start<=timeslice AND end>timeslice THEN 1 ELSE 0.
I keep thinking there is a named procedure for this, but can't remember
what it is.
IF you have any ideas, let me know..thanks
Stephen Oakley
| 
