Eirikur,

You're right. I will try to be more concrete.

Script for generating the data:

drop table #Test

create table #Test
(
    datum datetime,
    duration int,
)
insert...

I think I solved it!

As I brought today previous state, I also brough previosstate time into the table.

Now the table looks like this:

The only thing...

Pietlinden,

I am a bit confused with the code you wrote....I don't know what to modify in this query for me to work? Is it possible, be more precise, what exactly...

• This reply was modified 2 years, 11 months ago by  demokedes.

Jeff,

You're right this is not ok. Just this morning I alse remembered myself, I have some scenes implemented, which are turning off particular lights even if the light are in...

Dear pietlinden,

I managed to get duration for all records with the command:

SELECT x.deviceID
, x.friendlyName
, x.timestamp
, x.PrevEventTime
, Duration = CASE WHEN x.PrevEventTime IS NOT NULL THEN
DATEDIFF(second,x.PrevEventTime,x.timestamp) ELSE Null...

• This reply was modified 2 years, 11 months ago by  demokedes.

Uau pietlinden,

Thank you very much for your effort. I recreated your command and it totally makes sense. During tommorow I will try to "ingest" into my scenario.

Thank you once again!

Rok

Yes, record are always in pairs. It is not possible to turn on the switch unless to tuned if off first.

Can you please give me some more details siggestion..command...since I...