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.
| Author |
Topic |
|
skillile
Posting Yak Master
208 Posts |
 Posted - 2001-11-03 : 23:15:52
|
| Not even sure how to start. Any suggestions would be greatMy first impression is to use a pivot table with a bunch of case statements.table users-----------[UID] [NAME]1 john2 mary3 franktable events------------[EID] [UID] [DESC] [DATETIME]1 1 something 8/11 8:002 2 something 8/11 8:003 3 something 8/11 2:004 1 something 8/11 1:005 1 something 8/11 10:005 2 something 8/11 11:00-------------------------------------------NEEDED RESULT8/11[TIME] [JOHN] [MARY] [FRANK]8:00 x x9:0010:00 x11:00 x12:001:00 x2:00 x..slow down to move faster... |
|
|
|
|
|
Complex join Need expertise