Try this. UPDATE Table SET Description = CASE WHEN CodTID = '1' THEN (SELECT TOP 1 Description FROM Table WHERE CodTID = 2) WHEN CodTID ...
確定! 回上一頁