Getting maximum consecutive years in #SQLServer T-SQL using Common Table Expressions #CTE

(Donabel Santos) This is an expansion (and slight variation) of Joe’s answer in StackOverflow regarding the thread Find the maximum consecutive years for each ID’s in a table (Oracle SQL) using SQL Server. I’ve tested this in SQL Server 2014, but should work from SQL Server 2005 onwards where the ra

Read More - Register for Free Membership