Hi Lutz,

Thanks for your input to this post. My previous reply was just to say that we have solved this issue now. It's not ideal because we had to use...

Hi there.

Many thanks to all who replied to this post. Your help was much appreciated. I finally found a solution to this. The problem was as follows:

We are trying...

I have found a solution using the following simple sql, however it uses a temporary table which I unfortunately have been asked not to use:

USE ksubscribers

GO

Select MAX(eventtime) as TestDate

INTO #TheTestDates

From...