Code Test from Chrome

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734434

  More actions

  March 1, 2017 at 1:48 pm

  #322172

  Copy paste, Chrome 56.0.29xx
  
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