Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Post
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
1
Reply
Store Procedure not Return calculated result
Ajith kp
10 years ago
852
Reply
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
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
[C# net4] DropDownList disabled after change value
Word to PDF conversion