declare @SchemaName nvarchar(3) = 'dbo'
declare @TableName nvarchar(50) = 'MyTable'

declare @ColumnList nvarchar(max) = ''
declare @ColTypeList nvarchar(max) = ''

SELECT @ColumnList = @ColumnList + column_name + ',',
@ColTypeList = @ColTypeList + column_name + ' ' + DATA_TYPE 
+ (case 
	when CHARACTER_MAXIMUM_LENGTH is Null  then ''
	when CHARACTER_MAXIMUM_LENGTH = -1 then '(MAX)'
	else '(' + cast(CHARACTER_MAXIMUM_LENGTH as varchar) + ')'
end) 
+ ' ''' +  column_name + ''','
FROM INFORMATION_SCHEMA.Columns
WHERE table_name = @TableName
and TABLE_SCHEMA = @SchemaName
and DATA_TYPE <> 'timestamp'

select @ColumnList = SUBSTRING(@ColumnList,1,len(@ColumnList) -1), 
       @ColTypeList = SUBSTRING(@ColTypeList,1,len(@ColTypeList) -1)

declare @SQL nvarchar(max)
set @SQL =
 'declare @OldRow xml;'
+'Set @OldRow = /* Вставить свой код */ (select OldRowData from dbo.RChangeLog where... ;'
+ 'declare @idoc int; ' +
+' EXEC sp_xml_preparedocument @idoc OUTPUT, @OldRow ;'
+ ' insert into ' + @SchemaName +'.' + @TableName 
+' (' + @ColumnList +')'
+ 'select '
+ @ColumnList 
+ ' from openxml(@idoc, N''/Updated'',1)'
+ ' with ('+ @ColTypeList + ')'

exec(@SQL)