shift overlapp!!!!!!!!!

May 6 2019 6:03 AM
hi  friends 
 
this is my intime & outime&DATE here
 
 i need to check the intime &out  time depends upon date 
 
ex:
 
should not mapped another intime &outtime in same date 
if mapped its shows "shift time overlapped"
i dont know query in sql server 
hwlp mee friends  
 
DATE
2019-02-02
2019-03-03
2019-04-04
2019-05-05
2019-06-06

 
INTIME                                
 
09:30:00.0000000
10:00:00.0000000
09:30:00.0000000
09:30:00.0000000
10:00:00.0000000
 
OUTTIME 
18:30:00.0000000
19:00:00.0000000
18:30:00.0000000
18:30:00.0000000
19:00:00.0000000
 
 

Answers (4)