DECLARE @temp TABLE
(ID INT ,
Amt INT,
Dt DATE)
INSERT INTO @temp
SELECT 1,1000,GETDATE()
UPDATE @temp
SET Amt = Amt+1000,
Dt = CASE WHEN Amt = 2000 THEN NULL ELSE GETDATE()END
SELECT * FROM @temp
--Result------------
ID Amt Dt
1 2000 2010-10-26
If the values are not modified together then the result Dt Column should be updated with NULL.
No one has followed this question yet.