Here is a small part of the database, approximately 1000 rows of data.

http://www.camart.se/temp/db.zip

SELECT L1.[App_Name],

DATEDIFF(ss,MAX(L1.MESG_DATESTAMP),GETDATE()) as Seconds

FROM CSF_CME_LOG AS L1

JOIN CSF_LOGGER_LOG AS L2...

Here's the execution plan http://camart.se/temp/CSF.sqlplan

Hope this helps you help me 😀

Hello!

Thanks for your replies, I going to try this.

My execution plans looks like:

http://camart.se/temp/CSF.sqlplan