I have been trying to put an OR operator in CASE statement but it doesn't work.
Where W.Organization_ID =
CASE @IsAdmin OR @IsChiefEngineer
WHEN 1
THEN W.Organization_ID
ELSE @OrganizationID END
I want to check if any IsAdmin or IsChief engineer, either or they is 1 then Organization else @OrganizationID