http://msmvps.com/blogs/robfarley/archive/2007/01/17/set-based-approach-to-finding-consecutive-records.aspxI'm sure I've written about this before, but it comes up so regularly in the newsgroups that I thought I'd write an answer here. A table (probably an audit table) exists with a field that stores a date signifying when a change was made. You need to returnenCommunityServer 2008.5 SP2 (Build: 40407.4157)http://msmvps.com/blogs/robfarley/archive/2007/01/17/set-based-approach-to-finding-consecutive-records.aspx#1653458Fri, 07 Nov 2008 22:43:14 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1653458Theresa<p>Thank you so much for this solution! It saved a lot of time for coding (I was going to try cursor) and is so simple! Thank you!</p> <div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1653458" width="1" height="1">http://msmvps.com/blogs/robfarley/archive/2007/01/17/set-based-approach-to-finding-consecutive-records.aspx#1039497Thu, 19 Jul 2007 15:03:29 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1039497Wentu<p>Thank you very much for this wonderful piece of code, you saved my day !</p> <p>Wentu</p> <div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1039497" width="1" height="1">