UPDATE Temp1 a SET TimeStamp1 = CASE(WHEN (a.TimeStamp1 IN(SELECT TimeStamp1 FROM a WHERE a.DealName = 'Disha Rufous' AND a.DealStep = 'Sent for Risk feedback') - a.TimeStamp1 IN(SELECT TimeStamp1 FROM a WHERE a.DealName = 'Disha Rufous' AND a.DealStep = 'De-dupe confirmation received') IS NOT NULL THEN '0' ELSE TimeStamp1 END) WHERE Temp1.DealName = 'dede' AND Temp1.StepName = 'Risk feedback addressed'
THEN
-
a.TimeStamp1 In (...)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)