Thanks very much for taking the time to look at this Eirikur, this works well.

Thanks Jimbob, I ran this over a few sample datasets in dev this morning, and this query is returning exactly the results I am after, much appreciated

No mike, it's the same issue, I'm not doing a good job of explaining what I need, I'm going to have another go at it, so drop exapmlelog if you...

I need to find a way of limiting the partitions from the cte to rows that have occurred within a 5 minute of the latest timestamp in the partition, so...

WITH...

I’m still not over the line with this one, what I’ve found is my sub query doesn’t appear to be doing what I want, I get the exact same...

OK capn, this is great stuff,

I'm also going to use a sub query to return rows where the timestamp is within + 5 minutes after each of the rows returned...

Sorry guys, I read the forum etiquette, quite right too....

CREATE TABLE [dbo].[ExampleLog](

[ID] [uniqueidentifier] NOT NULL,

[EVENTNUMBER] [int] NULL,

[DISPLAYSERIAL] [int] NULL,

[DISPLAYID] [varchar](50) NULL,

[OBJECTSERIAL] [int] NULL,

[OBJECTRSSILEVEL] [int] NULL,

[OBJECTID] [varchar](50) NULL,

[TIMESTAMP] [datetime] NULL)

INSERT INTO...

Update: I figured this one out, this is what I did, for anyone searching for a similar solution:

CREATE TRIGGER [trgname]

ON [tblname]

AFTER INSERT

AS

BEGIN

...

SSIS file system task looks like the go, thanks very much