Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select ks.CalendarId
- , ks.machineid
- , ks.machinestateid
- , lead(ks.machinestateid) over (partition by ks.machineid, ks.calendarid order by ks.machinefmstatetime desc) prevstateid
- , ks.machinestatehistoryid
- , ks.machinefmstatetime
- , ks.StateTimeInSeconds
- , sum(ks.statetimeinseconds) over (partition by ks.machineid, ks.calendarid, ks.machinestateid order by ks.machinefmstatetime) StateTimeSecTotal
- from [dbo].[MachineStateDailyDistributionFact] ks
- where calendarid in (20180425)
- and ks.machineid in (38141)
- order by ks.MachineFmStateTime
Add Comment
Please, Sign In to add comment