Agreed, always look to use new features.

We have a couple of old 2008R2 servers and are sometimes forced to go old school on a few queries, hence my post.

I'd be...

Alternative method for those without LEAD() and LAG()

WITH cteSAMPLEDATA

AS (--Create Sample data

SELECT ID, ORDER_ID, CODE, ORDER_DATE FROM

...

My summer has consisted of a week in rural Turkey...away from all technology!

I find a break away from everything that could be even tenuously associated with work allows me to...