Code Test from Edge

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734564

  More actions

  March 1, 2017 at 1:49 pm

  #328067

  Win10, 38.14.xx
  
CREATE OR ALTER PROCEDURE RunTimeTests
AS
BEGIN
    SELECT
        Taskid,
        MIN(StartTime),
        MAX(EndTime),
        DATEDIFF(MINUTE, MIN(StartTime), MAX(EndTime)),
  ReferenceDate = '2017-02-23 10:11:47.413'
    FROM TimeTests
    GROUP BY Taskid;
END;
GO