Welcome back ALZDBA.

well In fact I found something

declare @schedule table ( EMP nvarchar(10), Date datetime, TimeIn datetime, TimeOut datetime)

declare @emp table ( EMP nvarchar(10), Date ...

I loved your comment 🙂

But still, the problem exist and their is no solution for this question till now..

hope to find an answer in this forums..

so!

no one want to help me a bit on this part ?

if @chek_out is null

...

First of all, Thank you very much indeed for your help

about the night shift question:

logically the employee mush check out and then in the night shift he must check...

in fact yes I am using sql server 2008

for the date I am using Date type

for the time I am using Datetime value

in fact i have an idea to add...