Thanks for the reply Sean. I think I have read this article at one time but couldn't figure out how to apply it in this scenario. The problem is that there is nothing to unique records on or to group by. Each combination of Station + Start time will be unique, and since there could be multiple islands per day, you can't group on the date.

Here is the ddl and sample data.

Let me know what creative ideas you have.

Thanks,

Tad

DECLARE @Events TABLE(StationID VARCHAR(10), dtmStart DateTime, dtmEnd DateTime)

INSERT INTO @Events(StationID, dtmStart, dtmEnd)

VALUES

('WKBW','7/05/13 11:00','7/05/13 11:30'),

('WKBW','7/05/13 12:00','7/05/13 12:30'),

('WKBW','7/05/13 12:30','7/05/13 13:00'),

('WKBW','7/05/13 13:00','7/5/13 1:30 PM'),

('WKBW','7/05/13 13:30','7/5/13 2:00 PM'),

('WKBW','7/09/13 11:30','7/09/13 12:00'),

('WKBW','7/09/13 12:00','7/09/13 12:30'),

('WKBW','7/12/13 12:30','7/12/13 13:00'),

('WKBW','7/12/13 13:00','7/12/13 13:30'),

('WKBW','7/12/13 13:30','7/12/13 14:00'),

('WKBW','7/17/13 12:00','7/17/13 13:00'),

('WKBW','7/18/13 13:30','7/18/13 14:00'),

('WKBW','7/19/13 12:30','7/19/13 13:00'),

('WKBW','7/19/13 13:00','7/19/13 13:30'),

('WKBW','7/19/13 13:30','7/19/13 14:00'),

('WKBW','7/19/13 15:00','7/19/13 16:00'),

('KFUN','7/22/13 04:30','7/22/13 07:00'),

('KFUN','7/22/13 07:00','7/22/13 09:00'),

('KFUN','7/22/13 12:00','7/22/13 12:30'),

('KFUN','7/22/13 17:00','7/22/13 18:30'),

('KFUN','7/23/13 04:30','7/23/13 07:00'),

('KFUN','7/23/13 07:00','7/23/13 09:00'),

('KFUN','7/23/13 09:30','7/23/13 10:00'),

('KFUN','7/23/13 10:00','7/23/13 10:47'),

('KFUN','7/23/13 10:53','7/23/13 11:18'),

('KFUN','7/23/13 11:18','7/23/13 11:54'),

('KFUN','7/23/13 12:00','7/23/13 12:30'),

('KFUN','7/23/13 17:00','7/23/13 18:30'),

('KFUN','7/23/13 21:00','7/23/13 22:30'),

('KFUN','7/24/13 04:30','7/24/13 07:00'),

('KFUN','7/24/13 07:00','7/24/13 09:00'),

('KFUN','7/24/13 21:00','7/24/13 22:30'),

('KFUN','7/25/13 04:30','7/25/13 07:00'),

('KFUN','7/25/13 07:00','7/25/13 09:00')