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
 Transact-SQL (2000)
 Pivot Table, Shape Command Cross Tab ??

Author  Topic 

skillile
Posting Yak Master

208 Posts

Posted - 2001-10-31 : 20:07:07
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.

Thanks in advance



slow down to move faster...
   

- Advertisement -