nice but it doesnt work, because of Order by,  I've try and it give an Error but if I comment Order By, it works, but not what I want

Hy @Chris Stewart it doesn't work my friend, it because of order by

I got an Info that Order by cannot used as Sub Query

Yes, It Works !!! Thank You Very Much @Vitaliy Serdtsev

Hy @Oliver Thompson 

Sure, I'm trying to calculate the difference between the 2 dates/times, but the problem is, it has a different columns (date and time), so does it mean that I've to combine it into 1 columns (Ex: DateTimeorder ->combine Date and Time Order, and DateTimeUpdate -> combine date update and time update) then calculate them or any other way to do it ?

Thank You

Steven Henry

Dear @Oliver Thompson
it works, thank you

Dear @Ramil TK 

it works, thank you

Dear @Manel Trèmols 
Thank you, it works for me

Dear @Robert Cemper 
thank you :)

Hy Robert, thank you for your help

but can I use Query without store procedure ?

Thank you

Steve Henry

Dar Andreas,

thanks for your help

it works for me :)

Thank you