Hello nosepicker, I realize this is a very old post. I wanted to know if you could help me write a SQL Server query of along the lines of your table below

SELECT x1.id, x1.date, DATEDIFF(mi, x2.date, x1.date)
FROM x AS x1 LEFT JOIN x AS x2
ON x1.id = x2.id +1
I need to write to a query. I would like to pull the elapsed time as noted above and write the query to another table for results. When I use Insert to it errors out.