2
Answers

how to use case query for this task

siva nathan

siva nathan

7y
241
1
 intime outtime
 08:45 18:11
 08:30 20:15
i have a table ,in that table i have intime,outtime
if datediff(hour,'08:45','20:15') hour difference 4 or 5 means put  /
if hour difference 7 or 8 (between 7 and 8) means X
greater than 11 means  X/
Answers (2)
0
Nitin Sontakke

Nitin Sontakke

NA 11.7k 2.2k 7y
Always SHOW the expected output with ALL possible scenarios. DO NOT assume anything.
0
Ben Chris

Ben Chris

35 5.5k 1.1m 7y
Can you elaborate your question a bit more?