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

10:00:00.0000000

OUTTIME

18:30:00.0000000

19:00:00.0000000

18:30:00.0000000

19:00:00.0000000

Answers (4)

What is wrong here??