>I see, I think I have an idea.
>
>Do you store the LastDate processed somewhere and Pass this date to get everything up from that date?
Yes, this is what we rely on. This is sent to the server for each of those10 records. I save in a related table the last LastDate. Then, once the client requests to start the process again, I send the LastUpdate value.
The query can then use that LastUpdate value like this:
SELECT RO.FirstName
FROM (SELECT TOP 10 Event.RO_No,Min(Event.DateTime) AS LastUpdate
FROM Event
INNER JOIN RO ON Temp.RO_No=RO.RO_No
WHERE Event_Log.Event_DateTime>'Something'
GROUP BY Event.RO_No
ORDER BY MIN(Event.Datetime)) Temp
INNER JOIN RO ON Temp.RO_No=RO.RO_No