BEGIN TRAN

CREATE TABLE yourTable (yourTableID INT IDENTITY, column1 VARCHAR(500), column2 VARCHAR(500))

INSERT INTO yourTable (column1)

SELECT '2 * 2+1 * 7'

UNION ALL SELECT '1 * 1+2 * 4'

UNION ALL SELECT '1 * 1+2 * 4+1 * 4'

DECLARE @SQL AS VARCHAR(MAX)

SELECT @SQL = COALESCE(@SQL + ';' + CHAR(10),'') +

'UPDATE yourTable SET column2= ' + column1 + ' WHERE yourTableID = '+CAST(yourTableID AS VARCHAR(3))

FROM yourTable

PRINT @SQL

EXEC(@SQL)

--Check results

SELECT * FROM yourTable

ROLLBACK