SQL conditional update query

Question

I have:
Table with columns A int, B int, C int

I need to build query like:

UPDATE
    Table
SET
    A -= B -- and then if A < 0 do A = C

Is it possible to do without cursor? If it is useful, I use MS SQL Server 2008.

Conrad Frix · Accepted Answer · 2011-05-17 18:45:51Z

8

If I understood correctly this is what you're looking for

UPDATE
    Table
SET
    A = CASE 
           WHEN (A - B) < 0 THEN
             C
           ELSE 
               (A - B)
         END

answered May 17, 2011 at 18:45

Conrad Frix

52.8k13 gold badges100 silver badges158 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1