I would love to be able to use LAG and LEAD.

The 2nd solution works better for the original poster. I left the 1st post in to show how to get a running count by group and how I go about tackling a complex solution.

Feedback Thread Let Microsoft know you want LAG/LEAD in future releases of SQL Server.