1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| CREATE FUNCTION [dbo].[udf_PriceCalculation]
(@Qty as int,
@TopUpAmount as decimal(9,2),
@Value as decimal(9,2),
@PostMethod as bit,
@CourierMethod as bit,
@Formula AS varchar(max))
RETURNS decimal(9,3)
AS
Begin
set @formula = replace(@formula, '@Qty', @Qty)
set @formula = replace(@formula, '@TopUpAmount', @TopUpAmount)
set @formula = replace(@formula, '@Value', @Value)
set @formula = replace(@formula, '@PostMethod', @PostMethod)
set @formula = replace(@formula, '@CourierMethod', @CourierMethod)
declare @ret decimal(9,3)
exec @ret ('select ' + @formula)
return @ret
end
GO |
Partager