Code Test from FF

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734564

  More actions

  March 1, 2017 at 1:46 pm

  #335416

  Posting from FF (51.0.1), copy paste from SSMS.
  
CREATE OR ALTER PROCEDURE RunTimeTests
AS
BEGIN
  SELECT
   Taskid,
   MIN(StartTime),
   MAX(EndTime),
   DATEDIFF(MINUTE, MIN(StartTime), MAX(EndTime))
  FROM TimeTests
  GROUP BY Taskid;
END;
GO