Hi,
How to get desired outlike below...
Type No. User DAY1 DAY2 DAY3 DAY4 DAY5
Type #1 0 ABC NULL NULL NULL NULL NULL
1 WE 2009-07-10 09:30:00.000 NULL NULL NULL NULL
2 WE NULL 2009-07-10 11:00:00.000 NULL NULL NULL
3 WE NULL NULL 2009-07-10 12:18:00.000 NULL NULL
4 WE NULL NULL NULL 2009-07-10 15:42:00.000 NULL
5 WE NULL NULL NULL NULL 2009-07-10 18:54:00.000 output as below
Type No. User DAY1 DAY2 DAY3 DAY4 DAY5
Type #1 0 ABC NULL NULL NULL NULL NULL
1 WE 2009-07-10 09:30:00.000 2009-07-10 11:00:00.000 2009-07-10 12:18:00.000 2009-07-10 15:42:00.0