Loading

Store Procedure not Return calculated result

Ajith kp

12y1.4k.NET

sir

ALTER PROCEDURE [dbo].[GL_IntrestCalculation]

@bal_amt numeric(10,2),

@intrst_rate decimal(6,3),

@dueDateCount decimal(6,3) ,

@result DECIMAL(5,3) out

AS

BEGIN

Declare @str nvarchar(MAX);

SET @str = '@bal_amt + @intrst_rate + @dueDateCount / 360'

select cast(@str AS decimal(5,3))

set @result=@str

return (@result)

END.

here throgh program am passing @bal_amt,@intrst_rate,@dueDateCount these three values and after that i want to return the @result answer to the textbox... help me sir

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Riyaz Akhtar12y ago
Accepted answer
return keyword is not suitable for your requirement.
see below link to know more about return keyword:
http://technet.microsoft.com/en-us/library/ms174998.aspx

Use Select instead of return, I have modified your code ,see below:

ALTER PROCEDURE [dbo].[GL_IntrestCalculation]
@bal_amt numeric(10,2),
@intrst_rate decimal(6,3),
@dueDateCount decimal(6,3)
AS
BEGIN
Declare @str decimal(6,3);
SET @str =@bal_amt + @intrst_rate + @dueDateCount / 360
select @str as 'result'
END
0