1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
|
; WITH Q AS (
SELECT [KSK]
,[Operation]
,[Workplace]
,[Route]
,[RouteStep]
,[Location]
,[StartTime]
,[CompleteTime]
,[WorkTime]
,[DispositionCode]
,[CreateTime]
,[ErrorCode]
FROM [LEPS].[LEP_HIS].[WorkTimes]
WHERE RouteStep = '20'
AND CompleteTime BETWEEN '2010-06-16 14:00:00' AND '2010-06-16 22:00:00'
)
SELECT
*
FROM (
SELECT DISTINCT [KSK] FROM Q
) E1
CROSS APPLY (
SELECT TOP(1)
[Operation]
,[Workplace]
,[Route]
,[RouteStep]
,[Location]
,[StartTime]
,[CompleteTime]
,[WorkTime]
,[DispositionCode]
,[CreateTime]
,[ErrorCode]
FROM Q
WHERE Q.[KSK] = E1.[KSK]
) AS E2
ORDER BY worktime |
Partager