Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT [BelongsToOrderNo]
- ,[OrdersId]
- ,[OrderNo]
- ,[OpNo]
- ,[StartTime]
- ,[EndTime]
- ,[DatasetId]
- ,[DemandDate]
- ,[OpId]
- ,[PartNo]
- ,NextTime
- ,NextOrder
- FROM (
- SELECT [BelongsToOrderNo]
- ,[OrdersId]
- ,[OrderNo]
- ,[OpNo]
- ,[StartTime]
- ,[EndTime]
- ,[DatasetId]
- ,[DemandDate]
- ,[OpId]
- ,[PartNo]
- ,LEAD(StartTime) OVER (ORDER BY OrderNo) As NextTime
- ,LEAD(OrderNo) OVER (ORDER BY OrderNo) As NextOrder
- FROM [AS Ultimate v16.4].[UserData].[Orders]
- ) AS TabelkaAgi
- where DatasetId = '15' and NextTime.Value < EndTime
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement