Using LAG and LEAD Window Functions with Multiple Partitions in SQL Server Without PARTITION BY Clause

Converting and Calculating Lost Time in SQL: Best Practices and Alternative Solutions.