I have a case statement that is supposed to return different answers depending on the criteria in the when clause:
Select [Unit Name], StartDate, EndDate, Operation, Production, 'Availability' =
case when Operation = 'PO' or Operation = 'IR' or Operation = 'MB' or Operation = 'ME' and Production = '0' and <strong><span style="text-decoration:underline">EndDate is null</span></strong> then 'Unavailable'
If the case is anything else other tha
View Complete Post