Viewing 3 posts - 1 through 3 (of 3 total)
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...
November 22, 2011 at 6:58 am
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]...
November 21, 2011 at 5:54 pm
------considering execution for many rows-----------------
DECLARE @ExprCollection Table(expr VARCHAR(100) )
INSERT INTO @ExprCollection(expr)
SELECT '2+1'
UNION ALL
...
November 21, 2011 at 1:53 pm
Viewing 3 posts - 1 through 3 (of 3 total)