这是我的疑问: SUM(CASE WHEN datename(month, [CheckIn]) = 'January' or datename(month, [CheckOut' or datename(month, [CheckOut]) = 'February' THEN 1 ELSE 0 END) February,
SUM(CASE WHEN datenameSUM(CASE WHEN datename</
我想要比下面更简洁的东西
if ((DATENAME(WEEKDAY, @date) = 'Monday' or DATENAME(WEEKDAY, @date) = 'Tuesday' or DATENAME(WEEKDAY, @date) = 'Wednesday' or DATENAME(WEEKDAY, @date) = 'Thursday' or DATENAME(WEEKDAY, @date) =