SQL Server query
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

Pradeep ChandrakerPosted Jun 23, 2011, 11:09 PM
select name, max(day1) 'day1', max(day2) 'day2', max(day3) 'day3', max(day4) 'day4', max(day5) 'day5'
from MyTable
group by name