Do not normally direct others to sites from the one the forum is on, this is another good explanation and illustration of LEAD and LAG: http://blog.sqlauthority.com/2011/11/15/sql-server-introduction-to-lead-and-lag-analytic-functions-introduced-in-sql-server-2012/