DECLARE @Amount NUMERIC(16,2) SELECT @Amount=isnull(64400.00,0) * (Power((1 +(ISNULL(Amount,0.00)/100)),isnull(13,0))-1) FROM biz_FineSetup WHERE FeeHeadID=80 AND ClassID=42 AND SectionID=299 AND CategoryID=12 AND SchoolID=1 SELECT @Amount
30173.59
3087
isnull(64400.00,0)
isnull(13,0)
64400.00
13
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)