I need to create a query in SQL for an Excel statement which goes like ..
Check status , If its Yes then 'WithinStatus'
If it is not yes then check Hours and if Hours is < Benchmark then 'OutsideStatus' otherwise InsideStatus
I started with Case statement but then I am confused...
Case when Status = 'Yes' then 'WithinStatus'
Case when Hours< Benchmark Then 'OutsideStatus'
End as StatusType.
Don't know how to go with the other Else....