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
|
Results 1 to 3 of 3
Thread: Need help sql case statement!!!!Threaded View
|
Click Here to Expand Forum to Full Width |