试试这些 -

连续统计日期使用SQL [ ^ ]

http://bytes.com/topic/sql-server/answers/861048-how-find-x-consecutive-integer-values-table-column [ ^ ]

http://ask.sqlservercentral.com/questions/17524/how-to-find-records-with-3-consecutive-same-values.html [ ^ ]

Try these -
Counting Consecutive Dates Using SQL[^]
http://bytes.com/topic/sql-server/answers/861048-how-find-x-consecutive-integer-values-table-column[^]
http://ask.sqlservercentral.com/questions/17524/how-to-find-records-with-3-consecutive-same-values.html[^]