DECLARE @FILE_NAME_OLD NVARCHAR(MAX) = NULL, @FILE_NAME_NEW NVARCHAR(MAX) = NULL, @PATH_NEW NVARCHAR(MAX) = NULL -- SELECT TOP 1 @FILE_NAME_OLD = FILE_NAME_OLD, @FILE_NAME_NEW = FILE_NAME_NEW, @PATH_NEW = PATH_NEW FROM CM_ATTACH_FILE_HIST WHERE ID = 25831 -- UPDATE CM_ATTACH_FILE SET FILE_NAME_OLD = @FILE_NAME_OLD, FILE_NAME_NEW = @FILE_NAME_NEW, PATH_NEW = @PATH_NEW WHERE ATTACH_ID = 'CMAF00000769607'