Hi Guys,

Thanks for the feedback, and yes.... My bad, i left ONE line of code in that is SQL 2012 specific, if you comment out line 77, the code will work in 2005 (i tested it with build 4053).

--,CAST(STUFF(STUFF(REPLACE(STR(run_duration, 6), ' ', '0'), 3, 0, ':'), 6, 0, ':') AS time(0)) AS Duration

@lee Linares: The link points to a EXCEL 2010 sheet, not a zip file.

@adam-2 Seniuk: you can set the resolution here (down to 1 minute) : set @resolution = 1 -- Enter the Resolution in minutes

Theo 🙂