Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mariechristine
Starting Member
27 Posts |
 Posted - 2004-07-09 : 11:12:11
|
| I have the tables SendController (controllerID int, date datetime, regionID int, mission ntext)i want to select all controllers that didn't go to the same region 10 times consecutively. How to do that??? |
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2004-07-09 : 12:12:25
|
| I think you need to search here for "Runs and Streaks in data".There was an article discussing this. |
 |
|
|
|
|
|
HelpQuery