How can I turn a bunch of rows into aggregated columns WITHOUT using pivot in SQL Server 2005?
- by cdeszaq
Here is the scenario:
I have a table that records the user_id, the module_id, and the date/time the module was viewed.
eg.
Table: Log
------------------------------
User_ID Module_ID Date
------------------------------
1 red 2001-01-01
1 green 2001-01-02
1 blue 2001-01-03
2 green 2001-01-04
2 …