is there a way to do this with a case statement?


update #totals
set cutoff = '3:00pm'
where id in (14,15)

update #totals
set cutoff = '1:00pm'
where id in (16)

update #totals
set cutoff = '12:00pm'
where id in (17,18,19,20)

update #totals
set cutoff = '9:00am'
where id in (21)

update #totals
set cutoff = '2:40pm'
where id in (22)