declare @tab TABLE( WS int, WSStartTime datetime, WSEndTime datetime, WSLstModTime datetime, EqtActual varchar(10), MatActual varchar(10))
insert into @tab
SELECT 1001, '1-15-13 22:35', '1-15-13 23:39', '1-15-13 22:19', '001INI', NULL union all
SELECT 1001, '1-15-13 23:35', NULL, '1-15-13 23:51', NULL, NULL union all
SELECT 1001, '1-15-13 23:35', '1-15-13 23:49', '1-15-13 20:18', NULL, 'F1516' union all
SELECT 1210, '1-15-13 18:30', NULL, '1-16-13 8:46', '005VERBO', NULL union all
SELECT 1210, '1-15-13 19:30', NULL, '1-16-13 9:46', NULL, '123456' union all
SELECT 1210, '1-15-13 20:30', '1-16-13 10:46', '1-16-13 10:46', NULL, NULL
SELECT ws, MIN(wsstarttime), MAX( WSEndtime), MAX(WSLstModTime), MAX(EqtActual), MAX(MatActual)
FROM @tab
GROUP BY ws
--
Chandu
Select min and max for distinct id(rows) from colu
Posted - 01/16/2013 : 05:40:26
