Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Monday, July 3, 2017

Running total for previous 7 values where there is a 1

SQLServerCentral » Latest topics
Running total for previous 7 values where there is a 1
Hi I need a flag to tell me there is 7 1s in a row per site

This would class as a long run

Anyone get an ideas? i have been trying for some while
Please note that the databases are not compatible with lag/lead
thanks in advance

No comments: