DECLARE @sql NVARCHAR(MAX)
DECLARE @table NVARCHAR(32)
SET @table = N'INSERT TABLE NAME HERE'
SET @sql = ''
SELECT @sql = @sql + ', [' + f.[name] + '] = (' + a.[value] + ')' + CHAR(10) FROM [attributedata] AS a
                                                                                                   INNER JOIN [field] AS f ON a.[idrecord] = f.[idfield]
                                                                                                   INNER JOIN [table] AS t ON f.[idtable] = t.[idtable]
                                                                                                   WHERE a.[owner] = 'field'
                                                                                                   AND [a].[name] ='onsqlupdate'
                                                                                                   AND t.[name] = @table

SET @sql = 'UPDATE ['+ @table +'] SET [status] = [status] ' + @sql
SET @sql = @sql + ' WHERE [status] = 0'
EXECUTE(@sql)