Need help sql case statement!!!!

[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)

[RogerH]

Yes (MS SQL Server 7.0):

UPDATE #totals set cutoff =
CASE id
when 14 then '3:00pm'
when 15 then '3:00pm'
when 16 then '1:00pm
...
END

That's it!

Roger

case is available in SQL Server 6.5 too!