Just copy to Manag Stu and run....

Can some one improve my solution:

------considering execution for many rows-----------------

DECLARE @ExprCollection Table(expr VARCHAR(100) )

INSERT INTO @ExprCollection(expr)

SELECT '2+1'

UNION ALL

SELECT '5*2'

UNION ALL

SELECT '6/3'

DECLARE @genSql...

Can some one improve my solution:

------considering execution for many rows-----------------

DECLARE @ExprCollection Table(expr VARCHAR(100) )

INSERT INTO @ExprCollection(expr)

SELECT '2+1'

UNION ALL

SELECT '5*2'

UNION ALL

SELECT '6/3'

DECLARE @genSql AS VARCHAR(MAX)

CREATE TABLE #ExpValueTable ([value] INT,[Id_Exp]...

------considering execution for many rows-----------------

DECLARE @ExprCollection Table(expr VARCHAR(100) )

INSERT INTO @ExprCollection(expr)

SELECT '2+1'

UNION ALL

...