• We are on 2012, so I tried to do this with LEAD()..

    You posted in the wrong forum SQL Server 7,2000