Decimal places not returning from a stored procedure
Posted on 2001-07-11
I have a stored procedure which should be returning a percentage back to the ASP page.
The problem is it is rounding up to the nearest whole number and not returning the decimal places.
The relevant parts of the stored procedure are as follows(the variable used to return the percentage is @result4):
CREATE PROCEDURE sp_highlevelsummaryrpt
@result4 int output
declare @discinc decimal
if (@discinc is null)
set @discinc = '0'
set @discinc = (select Approved_Disc_Inc from pr_misc)
set @result4 = @discinc
In the ASP page, I am showing the variable on the page as follows:
result4 = cmd_Execute_stored_procedure.Parameters("@result4")
I have tried changing the data type in the stored to float, numeric but none work.
Can anyone help??