SELECT dbo.corooms.roomname, case when m.begintime between CONVERT(varchar(15),m.begintime, 110)+' 07:00:00' and CONVERT(varchar(15), m.begintime, 110)+' 14:59:00' then 1 else 0 end as ShiftType1 ...