Ajith kp

Ajith kp

  • 1.6k
  • 145
  • 33.5k

Store Procedure not Return calculated result

Feb 3 2014 12:20 PM
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
 

Answers (1)