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???



*** Sent via Devdex http://www.devdex.com ***

MC -

Probably want to try another news group. This one focuses on
Notification Services which is different than sending alerts or using
SQL Mail. Try microsoft.public.sqlserver.programming. There are some
bright folks that monitor that NG and they'll be able to help you.

HTH...
Joe Webb

[quoted text, click to view]