I should have spent yesterday working on a troublesome project at the office, but I badly needed a break from working on weekends and felt on a roll with my series on window functions, so I took the day and had some "fun" with LAG and LEAD. Here is a link to my results:
H.G. Wells and SQL: Travelling in the Second Dimension
This is the second in my series of articles on window functions in SQL Server 2012.