Precision Problem

[kaenmey]

Hi,

I can't seem to get a stored procedure to return decimal places. Here are the steps to re-create the problem:

--first create the following procedure
CREATE PROCEDURE test_precision
AS
BEGIN
RETURN 5.2
END

--then run the following code
DECLARE @x DECIMAL(18,2)
EXECUTE @x = test_precision
SELECT @x

I would like this code to return 5.20, but instead it returns 5.00. Any assistance would be greatly appreciated. Thanks.

[scripto]

if you are using SQL 2005 that is the problem. Your stored Procedure would work correctly in SQL 2000.

The work around
declare @x FLOAT(18,2)

give that a try.

[scripto]

ooops!! allow me to take that back - wrong thought process. sorry.

you need to edit your proc to read 5.20