Advertisement
Guest User

Untitled

a guest
Apr 20th, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.61 KB | None | 0 0
  1. SELECT [BelongsToOrderNo]
  2.      ,[OrdersId]
  3.      ,[OrderNo]
  4.      ,[OpNo]
  5.      ,[StartTime]
  6.      ,[EndTime]
  7.      ,[DatasetId]
  8.      ,[DemandDate]
  9.      ,[OpId]
  10.      ,[PartNo]
  11.      ,NextTime
  12.      ,NextOrder
  13. FROM (
  14. SELECT [BelongsToOrderNo]
  15.      ,[OrdersId]
  16.      ,[OrderNo]
  17.      ,[OpNo]
  18.      ,[StartTime]
  19.      ,[EndTime]
  20.      ,[DatasetId]
  21.      ,[DemandDate]
  22.      ,[OpId]
  23.      ,[PartNo]
  24.      ,LEAD(StartTime) OVER (ORDER BY OrderNo) As NextTime
  25.  ,LEAD(OrderNo) OVER (ORDER BY OrderNo) As NextOrder
  26. FROM [AS Ultimate v16.4].[UserData].[Orders]
  27. ) AS TabelkaAgi
  28. where DatasetId = '15' and NextTime.Value < EndTime
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement