Thanks
I have added these lines to my SP
DECLARE @sql nvarchar(512)
SET @sql = N'SELECT ' + @E
EXEC sp_executesql @query = @sql,@params = N'@V decimal(24,18) OUTPUT', @V = @V OUTPUT
Print @V
@E has been previously set to (0.093000000000+(0.75*0.00
This error is returned
Server: Msg 8115, Level 16, State 8, Line 101
Arithmetic overflow error converting numeric to data type numeric.
Main Topics
Browse All Topics





by: dsinePosted on 2005-10-09 at 21:57:34ID: 15050153
CREATE procedure calculate
@strIDs VarChar(100)
AS
BEGIN
DECLARE @i INT, @sql NVARCHAR(512)
SET @sql = N'SELECT ' + @strIDs
EXEC sp_executesql
@query = @sql,
@params = N'@i INT OUTPUT',
@i = @i OUTPUT
PRINT @i
END
GO
this should work... u can do this part in your orignal stored procedure returning the expression itself.