Hilare assisted with the creation of a NPER Function that works similar to excel.
This is the NPER Function
create function NPERTEST(@rate float, @payment float,@capital float)
select dbo.NPER(.203/12, 500, -5000) ---> returns 11.047592792208778
This works well and I haven't noticed a problem until this morning. Based on the value of the payment the procedure throws out a domain error occurred
Select dbo.NPERTEST(.203/12, 75, -5000) - Payment amount is R 75
Your urgent assistance is required
Thanks for your help in advance