Hi I have an update statement which performs UPDATES to column when the WHERE condone = 'Yes' ..
UPDATE dbo.Table1
SET colA = (SELECT col1 FROM Table2 WHERE col10 = 'A')
,SET colB = (SELECT col1 FROM Table2 WHERE col10 = 'A')
WHERE colC = 'Yes'
However, should the WHERE be equal to anything else apart from 'Yes' I would want the two columns to be SET to NULL.
I you could please help me out with the syntax.
Thank you