case statement with sql!!!

[Bebe]

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)

[Mongo]

Something along these lines may help...

CREATE VIEW v_NLT (id, cutofftm) AS
SELECT id,
CASE
WHEN id > 13 AND id < 16 THEN '3:00pm'
WHEN id = 16 THEN '1:00pm'
WHEN id > 16 AND id < 21 THEN '12:00pm'
WHEN id = 21 THEN '9:00am'
WHEN id = 22 THEN '2:40pm'
ELSE 'u/i'
END
FROM #totals
GROUP BY id;

UPDATE #totals
SET t.cutoff = v.cutofftm
FROM #totals AS t, v_NLT AS v
WHERE t.id = v.id