bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-01-16 : 06:04:56
|
[code]declare @tab TABLE( WS int, WSStartTime datetime, WSEndTime datetime, WSLstModTime datetime, EqtActual varchar(10), MatActual varchar(10))insert into @tabSELECT 1001, '1-15-13 22:35', '1-15-13 23:39', '1-15-13 22:19', '001INI', NULL union allSELECT 1001, '1-15-13 23:35', NULL, '1-15-13 23:51', NULL, NULL union allSELECT 1001, '1-15-13 23:35', '1-15-13 23:49', '1-15-13 20:18', NULL, 'F1516' union allSELECT 1210, '1-15-13 18:30', NULL, '1-16-13 8:46', '005VERBO', NULL union allSELECT 1210, '1-15-13 19:30', NULL, '1-16-13 9:46', NULL, '123456' union allSELECT 1210, '1-15-13 20:30', '1-16-13 10:46', '1-16-13 10:46', NULL, NULLSELECT ws, MIN(wsstarttime), MAX( WSEndtime), MAX(WSLstModTime), MAX(EqtActual), MAX(MatActual)FROM @tabGROUP BY ws[/code]--Chandu |
|
|