Prceisely.

Thanks a lot. that works fine as I want it to.

Thanks again.

🙂 Nice one.

I believe I did mention before the second set of table/columns that this is...

On Twitter, I was pointed out this link

http://www.sqlmag.com/content1/topic/calculating-concurrent-sessions-part-1/catpath/tsql3

But this does not resolve what I'm looking for.

This is in the direction, I tried modifying the code here, but not getting anywhere....

Its here!!

SET DATEFORMAT DMY

IF OBJECT_ID('#AgentResults2', 'U') IS NOT NULL DROP TABLE #AgentResults2;

CREATE TABLE #AgentResults2 (FUser_id varchar(48), FLoginDt datetime, FLogoutDt DateTime)

Insert Into #AgentResults2 (FUser_id , FLoginDt, FLogoutDt )

Select...

Thanks Jeff.

I'll be doing that really shortly. Have been working all night. Going to get some sleep.

Cheers