|
a4u6178
Starting Member
India
11 Posts |
 Posted - 03/12/2012 : 06:09:51
|
Hi all,
I am trying to calculate percentage value using scalar function it returns NULL result
Here is the function:
alter Function calculateComission
(@discount nvarchar(25),
@regFEE varchar(25),
@comissionPercentage nvarchar(25))
RETURNS varchar(25)
AS
BEGIN
DECLARE @dicountedREGFEE DECIMAL,@comission DECIMAL;
set @dicountedREGFEE=((cast(@discount as DECIMAL(18,2)) *cast(@regFEE as DECIMAL(18,2)))/100);
set @comission=((@dicountedREGFEE * cast(@comission as DECIMAL(18,4)))/100);
return @comission
END
calling function:
DECLARE @result DECIMAL
set @result=select dbo.calculateComission('20','29.01','4.5') as result
print @result
Thanks & Regards, |
|
scalar function for percentage returns NULL
