Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Pivot table, Shape, something

Author  Topic 

skillile
Posting Yak Master

208 Posts

Posted - 2001-10-31 : 21:55:35
I am trying to create a fully dynamic calendar table structure. I am referring to it as three dimensions for lack of a better term.

End result:


Time user1 user2 user3 user4 room1 room2 room3 | unassigned

8:00 event/2nd event event event
8:15
8:30
8:45
9:00
.
.
.

-I must allow for time views on 1/4, 1/2 3/4 and hour view
-users are variable and not set
-events have to be double booked on the time variable


Any help would be appreciated. I did see the dynamic pivot table example.



slow down to move faster...
   

- Advertisement -