How do I do this?

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Adam Machanic SSCoach Points: 15370 More actions · Answer 1

You can use a CASE expression for this:

UPDATE Table

SET qty_total = CASE WHEN (start_qty - end_qty) < 0 THEN 0 ELSE (start_qty - end_qty) END

--
Adam Machanic
whoisactive

Frank Kalis SSC Guru Points: 111183 More actions · Answer 2

What about

UPDATE Table

SET qty_total =

case when start_qty - end_qty < 0 then 0 else start_qty - end_qty end

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

Damn, beaten by 2 minutes, Adam!

Should take a course in fast typing

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Adam Machanic SSCoach Points: 15370 More actions · Answer 4

No worries, you've got me beat by 3300 posts already ... Too bad there's not a prize

--
Adam Machanic
whoisactive