T-SQL - 值与列表中的至少一个项不匹配

I have an MS SQL table with several columns, each for different employee roles, and a corresponding column for each indicating whether the current employee in that role is active, on leave, terminated, etc. Due to dependency on an external data source, the fields aren't really normalized.I have an MS SQL table with several columns, ea