Database

UPDATE TableName
SET ColB = CASE
              WHEN ColA < 0 THEN 0
              ELSE ColA
           END;

UPDATE TableName
SET ColB = CASE
              WHEN ColA >= 0 THEN 0
              ELSE ColA
           END

UPDATE table SET colB = DECODE( SIGN( colA ), -1, colA, 0 )

Mika Wendelius wrote:

you're sure the IF is not hit at all...

Mika Wendelius wrote:

call this procedure from another and check if you can handle the error properly in the calling procedure.

EXEC [spName]

IF(@@error <> 0)
BEGIN
	Print 'No error'
END
ELSE
BEGIN
	Print 'error'
END

WITH SalAgg as (
    SELECT  SUM(sal) sal
           ,DeptID
    From    Emp
    )
Select  deptid
       ,sal
       ,More info
       ,even more info
from    SalAgg s
join    Dept d
    On  s.deptid = d.deptid