Eirikur Eiriksson (7/21/2016)
Ed Wagner (7/21/2016)
Heh - And you even did it without a LEAD() for SQL 2008. Nice job, Eirikur.Done this or similar to this since 4.2, haven't forgotten it yet;-)
😎
I don't go back that far with SQL Server, but I do the same thing. 😉