Thanks Jack for all you help!

I do appreciate all you help and understand fully what is means to provide this kind of assistance as a volunteer. I do so...

Hi Jack,

The example work well for thelimited data set.

The problem comes in where there are hundreds of records.

For every record with Event Type 1 you are getting you are getting...

Table structure as follows:

CREATE TABLE AcivationData

(

MasterId int identity primary key nonclustered,

UnitId int not null,

RaisedTime datetime,

EventType int

)

e.g.

12345,1,30 March 2009 16:00,1

12346,2,30 March 2009...

Whoops apologies.

Each row had a DateTime field called 'RaisedTime'